ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

MONTH function [Date and time]

Function 

• Returns a number from 1 to 12 corresponding to the month of the given date.

Syntax 

MONTH ( date-expression )

Parameters 

date-expression    A 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 7.

SELECT MONTH( '1998-07-13' )