The SQL datepart function uses

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