When making a date interval into a literal in decimal representation, the data is represented as 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: