Supported Dateparts

You can use the following dateparts as arguments to the following functions:

Datepart	Aliases	Notes
epoch		Not supported for DATEADD.
millennium	millennia
century	centuries, cent, c
decade	decades, decs
year	years, yrs, yr, y
quarter	qtr
month	months, mons
week	weeks, w
day	days, d
dow		Not supported for DATEADD.
doy		Not supported for DATEADD.
isodow		Not supported for DATEADD.
isoyear
hour	hours, hrs, hr, h
minute	minutes, mins, min, m
second	seconds, secs, sec, s
microsecond	microseconds
millisecond	milliseconds, ms

Dateparts can be specified in uppercase or lowercase.

Parent topic:Datetime Functions