SQL Server DatePart and Abbrevations

The table lists date parts and abbreviations recognized by Microsoft SQL Server.

Datepart	Abbreviations
year	yy, yyyy
quarter	qq, q
month	mm, m
dayofyear	dy, y
day	dd, d
week	wk, ww
weekday	dw
hour	hh
minute	mi, n
second	ss, s
millisecond	ms

Eg:
SELECT DATEPART(m, 0), DATEPART(d, 0), DATEPART(yy, 0)