Date Rules

A date expression is a date value (because there are no natural arithmetic date operators). <Date Exp> consists of this:

<Date Value>

A date value is a function call returning a date value, or a date sub-expression enclosed in parentheses.

<Date Value> consists of one of these:

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Numeric Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Numeric Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Numeric Exp>, <Typeless Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Typeless Exp>, <Numeric Exp>, <Typeless Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Numeric Exp>)

DATE (<Typeless Exp>, <Typeless Exp>, <Typeless Exp> ',' <Typeless Exp>, <Typeless Exp>, <Typeless Exp>, <Typeless Exp>)

CURDATETIME()

DATEADD (<TimeInterval>, <Numeric Exp>, <Date Exp>)

DATEADD (<TimeInterval>, <Numeric Exp>, <Typeless Exp>)

DATEADD (<TimeInterval>, <Typeless Exp>, <Date Exp>)

DATEADD (<TimeInterval>, <Typeless Exp>, <Typeless Exp>)

BEGINDATE()

CAST (<Scalar Exp> AS DATE)

Sub-expression:

(<Date Exp>)

Date enumerations

<TimeInterval> consists of one of these:

<DatePartYear>

<DatePartQuarter>

<DatePartMonth>

<DatePartDayOfYear>

<DatePartDay>

<DatePartWeek>

<DatePartWeekDay>

<DatePartHour>

<DatePartMinute>

<DatePartSecond>

<DatePartMillisecond>

<DatePartYear> consists of one of these:

year

yy

yyyy

<DatePartQuarter> consists of one of these:

quarter

qq

q

<DatePartMonth> consists of one of these:

month

mm

m

<DatePartDayOfYear> consists of one of these:

dayofyear

dy

y

<DatePartDay> consists of one of these:

day

dd

d

<DatePartWeek> consists of one of these:

week

wk

ww

<DatePartWeekDay> consists of one of these:

weekday

dw

<DatePartHour> consists of one of these:

hour

hh

<DatePartMinute> consists of one of these:

minute

mi

n

<DatePartSecond> consists of one of these:

second

ss

s

<DatePartMillisecond> consists of one of these:

millisecond

ms