Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the month of the given date.
MONTH( date-expression )
date-expression A value of type DATE.
SMALLINT
The value returned is a number between 1 and 12, corresponding to the month of the given date.
The following statement returns the value 7:
SELECT MONTH( '1998-07-13' );
Syntax