Date parts

**Table 5-7: Date part values**
Date Part	Abbreviation	Values
Year	yy	0001 – 9999
Quarter	qq	1 - 4
Month	mm	1 - 12
Week	wk	1 - 54
Day	dd	1 - 31
Dayofyear	dy	1 - 366
Weekday	dw	1 - 7 (Sun.-Sat.)
Hour	hh	0 - 23
Minute	mi	0 - 59
Second	ss	0 - 59
Millisecond	ms	0 – 999
Calyearofweek	cyr	Integer. The year in which the week begins. The week containing the first few days of the year can be part of the last week of the previous year, depending on the weekday on which the year started. Years starting on Sunday through Wednesday have no days that are part of the previous year, but years starting on Thursday through Saturday start their first week on the last sunday of the previous year.
Calweekofyear	cwk	An integer from 1 to 54 representing the week number within the year that contains the specified date.
Caldayofweek	cdw	The day number within the week (Sunday = 1, Saturday = 7)

By default, Sunday is the first day of the week. To make Monday be the first day, set the following option:

set option ‘Date_First_Day_Of_Week’ = ‘1’

For compatibility with Adaptive Server Enterprise, use the Transact-SQL date and time functions.