December 2002
Intermediate to advanced
928 pages
85h 29m
English
The following examples illustrate various forms of the INTERVAL syntax and show the values to which they translate; see the next entry for INTERVAL YEAR TO MONTH syntax:
INTERVAL '10-4' YEAR(3) TO MONTH
10 years, 4 months
INTERVAL '10-4' YEAR TO MONTH
Error because first value exceeds default precision of 2
INTERVAL '240' MONTH
20 years
INTERVAL '5 4' DAY TO MINUTE
5 days and 4 minutes
INTERVAL '5 4' DAY TO HOUR
5 days and 4 hours
INTERVAL '3 11:15' DAY TO MINUTE
3 days, 11 hours, and 15 minutes
INTERVAL '20' DAY - INTERVAL '120' HOUR
15 days