TIMESTAMPDIFF function in EDS after applying 5.3.1_4 rollup patch

Solution Verified - Updated -


  • Red Hat JBoss Enterprise Data Services (EDS) 5.3.1
  • Roll up patch EDS_5.3.1_4_2013


  • Function TIMESTAMPDIFF with interval set to SQL_TSI_SECOND returns always 0. Please see sample query below. We have noticed this issue after we had applied "Roll up patch EDS_5.3.1_4_2013" on our environments.
select TIMESTAMPDIFF(SQL_TSI_SECOND,PARSETIMESTAMP('2013-09-03 18:29:58','yyyy-MM-dd hh:mm:ss'),PARSETIMESTAMP('2013-09-03 18:32:58','yyyy-MM-dd hh:mm:ss'))


This issue is resolved in Roll up patch EDS_5.3.1_1_2014

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.