Returns the name of the month from the specified date expression.
MONTHNAME ( date-expression )
Parameter
Description
date-expression
The datetime value.
VARCHAR
The following statement returns the value September, when the DATE_ORDER option is set to the default value of ymd.
SELECT MONTHNAME( '1998-09-05' ) FROM iq_dummy
SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise.