DATEPART
Returns an integer representing the specified date portion of the specified date.
Grammar
DATEPART ( datepart ,date )
Parameters
DatePart
is a parameter that specifies the date part that should be returned. The following table lists the date parts and abbreviations identified by Microsoft®sql Server™.
Date Part |
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 |
Additionally: When GROUP by DATEPART (yyyy,date), DATEPART (mm,date), DATEPART (dd,date) are grouped by date, the same method can be used instead of convert (varchar), date , 120) The effect of the two is the same, if you use the week as a group datepart (dw,date) DatePart return week is the number type of Use Datename (dw,date) can return Chinese characters form the week
The SQL datepart function uses