Date Intervals, Formats, and Functions


Examples of Interval Specifications

Table 4.1 shows examples of different kinds of interval specifications.

Table 4.1: Examples of Intervals

Name

Description of Interval

YEAR

Years that start in January

YEAR.10

Years that start in October

YEAR2.7

Biennial intervals that start in July of even years

YEAR2.19

Biennial intervals that start in July of odd years

YEAR4.11

Four-year intervals that start in November of leap years (frequency of U.S. presidential elections)

YEAR4.35

Four-year intervals that start in November of even years between leap years (frequency of U.S. midterm elections)

YEARV

Years that start on the Monday on or immediately preceding January 4th

YEARV.2

Years that start on the Monday immediately following January 4th

R445MON

Months that start on the 1st, 5th, 9th, 14th, 18th, 22nd, 27th, 31st, 35th, 40th, 44th, and 48th Monday of the year. The 1st Monday is the Monday on or immediately preceding January 4th

R445MON3

Three-month intervals that start on the 1st, 14th, 27th, and 40th Monday of the year. This is equivalent to R445QTR

R445MON3.2

Three-month intervals that start on the 5th, 18th, 31th, and 44th Monday of the year. This is equivalent to R445QTR.2

WEEK

Weekly intervals that start on Sundays

WEEK2

Biweekly intervals that start on first Sundays

WEEK1.1

Same as WEEK

WEEK.2

Weekly intervals that start on Mondays

WEEK6.3

Six-week intervals that start on first Tuesdays

WEEK6.11

Six-week intervals that start on second Wednesdays

WEEKDAY

Daily with Friday-Saturday-Sunday counted as the same day (five-day work week with a Saturday-Sunday weekend)

WEEKDAY17W

Same as WEEKDAY

WEEKDAY5.2

Five weekdays that start on Monday. If WEEKDAY data are accumulated into weekly data, the interval of the accumulated data is WEEKDAY5.2

WEEKDAY67W

Daily with Thursday-Friday-Saturday counted as the same day (five-day work week with a Friday-Saturday weekend)

WEEKDAY1W

Daily with Saturday-Sunday counted as the same day (six-day work week with a Sunday weekend)

WEEKDAY3.2

Three-weekday intervals (with Friday-Saturday-Sunday counted as one weekday) with the cycle three-weekday periods aligned to Monday, January 4, 1960

HOUR8.7

Eight-hour intervals that start at 6 a.m., 2 p.m., and 10 p.m. (might be used for work shifts)