3. QUEL Data Types : Data Types : Date Data Type : Date Interval Formats
 
Share this page                  
Date Interval Formats
Date intervals, like absolute date values, are entered as quoted character strings. You can specify date intervals in terms of years, months, days, or combinations of these. You can abbreviate years and months to yrs and mos, respectively. For example:
"5 years"
"8 months"
"14 days"
"5 yrs 8 mos 14 days"
"5 years 8 months"
"5 years 14 days"
"8 months 14 days"
The following table lists valid ranges for date intervals:
Date Interval
Range
Years
-9999 to +9999
Months
-119977 to +119977
Days
-3652047 to +3652047