WebSphere Message Brokers
File: ak17870_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:32:52

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. For details about when this problem can occur, and how to solve it, see The PutTime that is reported by WebSphere MQ on z/OS, and other times or timestamps are inconsistent.

Related concepts
Message flows overview
ESQL data types
Message mappings overview
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
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:32:52

ak17870_ This topic's URL is: