MONTHNAME Function [Date and Time]

Returns the name of the month from the specified date expression.

Syntax

MONTHNAMEdate-expression )

Parameters

Parameter

Description

date-expression

The datetime value.

Returns

VARCHAR

Example

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

See Reference: Statements and Options > Database Options > Alphabetical List of Options > DATE_ORDER Option.

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.