Interval Data Types
The INTERVAL data types include year to month and day to second intervals.
The format is as follows:
INTERVAL interval_qualifier
interval_qualifier
Defines an interval column as one of the following:
• YEAR TO MONTH
• DAY TO SECOND [(second_precision)]
where second_precision is the number of digits in the fractions of seconds field.
Note: When a value is entered that exceeds the specified precision, the value is truncated at the specified precision.
Examples: