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.

The PutTime reported by IBM® MQ on z/OS® and other times or timestamps can be inconsistent if the CVT field is not set correctly.