The Datename function in SQL2005

The main use of the sql2005| function Datename function is to extract the specified part of the data from the date, such as the year we want in the current date, the month, and so on. The return type is nvarchar.

The specific syntax is as follows:

Datename (param,date);

Param is the parameter that specifies the part of the date to return, including the following:

Date Part	abbreviation
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

Date is the specified day.

Example:

Select Datename (Year,getdate ()) as ' year '

Executing the SQL statement above will see the return value of ' 2006 '