ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the name of the specified part (such as the month "June") of a datetime value, as a character string.
DATENAME ( date-part, date-expression )
date-part The date-part to be named.
For a complete listing of allowed date-parts, see Date parts.
date-expression The date for which the date-part name is to be returned. The date must contain the requested date-part.
DATENAME returns a string, even if the result is numeric, such as 23 for the day.
SQL/92 Transact-SQL extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
The following statement returns the value May.
SELECT datename( month , '1987/05/02' )