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.