ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

MONTHNAME function [Date and time]

Function 

Returns the name of the month from a date.

Syntax 

MONTHNAME ( date-expression )

Parameters 

date-expression    The datetime value.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement returns the value September.

SELECT MONTHNAME( '1998-09-05' )