This function returns an integer value for the part of a date specified in the date part selection.
The syntax for DATEPART is:
DATEPART ( datepart , date )
The second parameter, date, designates the date for which the integer value is calculated.
datepart (Full Name) Abbreviation Values
year Yy 1753-9999
quarter Qq 1-4
month Mm 1-12
dayofyear Dy 1-366
day Dd 1-31
week Wk 1-53
weekday Dw 1-7 (Sunday-Saturday)
hour Hh 0-23
minute Mi 0-59
second Ss 0-59
millisecond Ms 0-999