Shifted Intervals

Date Intervals, Formats, and Functions

Shifted Intervals

Different kinds of intervals are shifted by different subperiods.

YEAR, SEMIYEAR, QTR, and MONTH intervals are shifted by calendar months.
WEEK, WEEKDAY, and DAY intervals are shifted by days.
SEMIMONTH intervals are shifted by semi-monthly periods.
TENDAY intervals are shifted by ten-day periods.
HOUR intervals are shifted by hours.
MINUTE intervals are shifted by minutes.
SECOND intervals are shifted by seconds.

If a subperiod is specified, the shift index cannot be greater than the number of subperiods in the whole interval. For example, you could use YEAR2.24, but YEAR2.25 would be an error because there is no twenty-fifth month in a two-year interval. For interval types that shift by subperiods that are the same as the basic interval type, only multiperiod intervals can be shifted.

For example, MONTH type intervals shift by MONTH subintervals; thus, monthly intervals cannot be shifted since there is only one month in MONTH. However, bimonthly intervals can be shifted, since there are two MONTH intervals in each MONTH2 interval. The interval name MONTH2.2 specifies bimonthly periods starting on the first day of even-numbered months.

Chapter Contents
Previous
Next
Top