1.4.5 Decimal representation of time interval data

Format:[Figure] hhmmss.

When making a time interval into a literal in decimal representation, the data is represented as [Figure] hhmmss. in terms of hour (hh), minute (mm), second (ss), and a sign (t), in fixed point with a precision of 6 and a scaling of 0.

Any time interval literal in decimal representation, when specified where time interval data is required, is converted into the time interval data type.

An example of turning a time interval into a literal in decimal representation is given as follows:

Example:
Representing an interval of 1 hour, 1 minute, and 1 second in decimal: 010101.