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 timestamp in single quotation marks in the form 'yyyy-mm-dd hh:mm:ss.ffffff'. For example:
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