Use of datename () in SQL

1. Get the week (display Chinese characters such as: Monday)

Select datename (DW, getdate ())

2. Obtain the quarter

Select datename (QQ, getdate ())

3. Days passed this year

Select datename (dy, getdate ())

4. the week of the current year

Select datename (wk, getdate ())

 

The second parameter specifies the date data. The first parameter is described as follows:

Date	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