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”