MONTHNAME function [Date and time]

Function

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

Syntax

MONTHNAME ( date-expression )

Parameters

date-expression The datetime value.

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

Standards and compatibility

SQL92 Vendor extension

Sybase Not supported by Adaptive Server Enterprise

See also

DATE_ORDER option in Reference: Statements and Options