DECLARE MyTimeStamp TIMESTAMP; SET MyTimeStamp = TIMESTAMP '1999-12-31 23:59:59';Do not omit leading zeroes in the year, month, and day.
Each of the hour, minute, and second fields in a TIMESTAMP literal must always be two digits; the optional fractional seconds field can be up to 6 digits in length.
Related concepts
Message flows
ESQL data types
Mappings
Related tasks
Developing message flow applications
Developing ESQL
Related reference
Built-in nodes
ESQL DATE data type
ESQL TIME data type
ESQL GMTTIME data type
ESQL GMTTIMESTAMP data type
ESQL INTERVAL data type
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak17890_ |