IBM Integration Bus, Version 10.0.0.9 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


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 WebSphere® MQ on z/OS® and other times or timestamps can be inconsistent if the CVT field is not set correctly.


ak17870_.htm | Last updated 2017-07-17 12:45:35