JDBC and HADB Date and Time Operations

• Use the 5800 system literal format for all the Date and Time operations, for example, {date '12-31-2007'}.

• The JDBC standard escape sequences for date ({d ’YYYY-mm-dd’}) and time ({t ’hh:mm:ss’}) literals are available. However, usage of JDBC format date and time literals may produce inconsistent results. In particular, when JDBC format is used, the literal format is interpreted as being relative to the local time zone, and the time zone usually differs between a 5800 system cluster and client machine.

• The following JDBC function escapes supported:

  TIMESTAMPDIFF, TIMESTAMPADD, CURRENT_TIMESTAMP, CURRENT_TIME, CURRENT_DATE, HOUR, MINUTE, SECOND.