1.4.6 Decimal representation of datetime interval data

Format:[Figure]YYYYMMDDhhmmss.

To represent a datetime interval in a decimal representation literal, represent the year (YYYY), month (MM), day (DD), hour (hh), minute (mm), second (ss), and a sign (t) as [Figure]YYYYMMDDhhmmss in fixed point with a precision of 14 and a scaling of 0.

The following is an example of representing a datetime interval in a decimal representation literal:

Example:
Representing an interval of 1 year, 2 months, 3 days, 4 hours, 5 minutes, and 6 seconds in decimal: 00010203040506.