ESQL GMTTIMESTAMP data type

The GMTTIMESTAMP data type is similar to the TIMESTAMP data type, except that the values are interpreted as values in Greenwich Mean Time.

GMTTIMESTAMP values are defined in a similar way to TIMESTAMP values, for example:

DECLARE MyGetGMTTimeStamp GMTTIMESTAMP;
SET MyGetGMTTimeStamp = GMTTIMESTAMP '1999-12-31 23:59:59.999999';

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.