The TIME data type holds a time of day in hours, minutes, seconds, and fractions of a second.
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.