DATENAME
Description
This function returns a character string representing the specified datepart of the specified date. (DATENAME in Transact-SQL).
Sample Source Pattern
Syntax
DATENAME ( datepart , date )
Examples
Code:
SELECT DATENAME(month, getdate()) AS DATE1,
DATENAME(day, getdate()) AS DATE2,
DATENAME(dw, GETDATE()) AS DATE3;
Result:
DATE1|DATE2|DATE3 |
-----+-----+-------+
May |3 |Tuesday|
Last updated