ESQL TIME data type

The TIME data type holds a time of day in hours, minutes, seconds, and fractions of a second. The format of a TIME literal is the word TIME followed by a space, followed by a time in single quotation marks in the form 'hh:mm:ss.ffffff'. For example:
DECLARE MyTime TIME;
SET MyTime = TIME '11:49:23.656';

Each of the hour, minute, and second fields in a TIME literal must always be two digits; the optional fractional seconds field can be up to 6 digits in length.

Related concepts
Message flows overview
ESQL data types
Mappings
Related tasks
Developing message flows
Developing ESQL
Related reference
Built-in nodes
ESQL DATE data type
ESQL GMTTIME data type
ESQL TIMESTAMP data type
ESQL GMTTIMESTAMP data type
ESQL INTERVAL data type
DECLARE statement