Data type of a temporal interval. There are two types of temporal intervals: day-time
intervals with up to nanosecond granularity or year-month intervals with up to month
An interval of day-time consists of
+days hours:months:seconds.fractional with values
-999999 23:59:59.999999999 to
+999999 23:59:59.999999999. The type
must be parameterized to one of the following resolutions: interval of days, interval of
days to hours, interval of days to minutes, interval of days to seconds, interval of hours,
interval of hours to minutes, interval of hours to seconds, interval of minutes,
interval of minutes to seconds, or interval of seconds. The value representation is the
same for all types of resolutions. For example, an interval of seconds of 70 is always
represented in an interval-of-days-to-seconds format (with default precisions):
An interval of year-month consists of
+years-months with values ranging from
+9999-11. The type must be parameterized to one of the following
resolutions: interval of years, interval of years to months, or interval of months. The
value representation is the same for all types of resolutions. For example, an interval
of months of 50 is always represented in an interval-of-years-to-months format (with
default year precision):
INTERVAL(DAY(2), SECOND(9)) for a day-time interval or
INTERVAL(YEAR(4), MONTH()) for a year-month interval.
Resolution, the upper resolution of the interval.
Resolution, the lower resolution of the interval.
the upper_resolution must be MONTH for YearMonthIntervalType, SECOND for
DayTimeIntervalType and the lower_resolution must be None currently.