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 date/time value.

Example

The following statement returns the value 7:

SELECT MONTH( '1998-07-13' ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension.

Sybase Not supported by Adaptive Server Enterprise.