The second part of a time literal can be omitted.The leading zeros of the hour parts can be skipped, for example, 01:00:00 is the same as 1:00:00.Time literals cannot have leading blanks but can have trailing blanks.
Time literals must conform to the following rules: Japanese industrial standard Christian era The first, second, and third bytes represent the hour, minute, and second respectively.ĭb2 stores time values in a special internal format and converts the time values to one of the following formats for the output: Format name Each byte consists of two packed decimal digits. Internally, DB2 uses three bytes to store a time value. Code language: SQL (Structured Query Language) ( sql )
