1.4.4 Decimal representation of date interval data

Format:[Figure] YYYYMMDD.

When making a date interval into a literal in decimal representation, the data is represented as [Figure] YYYYMMDD. in terms of year (YYYY), month (MM), day (DD), and a sign (s), in fixed point with a precision of 8 and a scaling of 0.

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

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

Example:
Representing an interval of 1 year, 1 month, and 1 day in decimal: 00010101.