WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
ESQL TIMESTAMP data type
The TIMESTAMP data type holds a DATE and a TIME in years, months, days, hours, minutes, seconds, and fractions of a second.
The format of a TIMESTAMP literal
is the word TIMESTAMP followed by a space, followed
by a time stamp in single quotation marks in the form 'yyyy-MM-dd
HH:mm:ss.SSSSSS'. For example:
DECLARE MyTimeStamp TIMESTAMP;
SET MyTimeStamp = TIMESTAMP '1999-12-31 23:59:59';
The year field must always be four digits in length. The month, day, hour, and minute fields must always be two digits. (Do not omit leading zeros.) The optional fractional seconds field can be 0 - 6 digits long.
For a description of the characters used when formatting a time stamp in the ESQL CAST function, see Formatting and parsing dateTimes as strings
The PutTime reported by WebSphere® MQ on z/OS® and other times or time stamps can be inconsistent if the CVT field is not set correctly.