Abbreviation of date variable in SQL

The date functions in SQL usually use the abbreviation of daypart.

Value	SQL Server)	(Access and Asp)	Description
Year	YY	Yyyy	1753 ~ 9999
Quarter	Qq	Q	Season 1 ~ 4
Month	Mm	M	Month 1 ~ 12
Day of year	Dy	Y	The number of days in a year. The number of days in a year is 1-366.
Day	Dd	D	, 1-31
Weekday	DW	W	The number of days in a week. The number of days in a week is 1-7.
Week	WK	WW	Week, week 0 ~ 51
Hour	HH	H	Time 0 ~ 23
Minute	Mi	N	Minute 0 ~ 59
Second	SS	S	Seconds 0 ~ 59
Millisecond	MS	-	Millisecond 0 ~ 999

Remember, you do not need to quote these abbreviations!