WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

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.

Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:47:14


Reference topicReference topic | Version 8.0.0.7 | ak17870_