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.
SQL/2008 Vendor extension.
The following statement returns the value 7.
SELECT MONTH( '1998-07-13' );