version 11
MONTH (arithmetic_expression)
Description
The MONTH function returns the number of the month (ranging from 1 to 12) of the date passed in the arithmetic_expression.
Example
Supposing that we have the PEOPLE table with a Date_of_Birth field. To find out the month of the date of birth for every person in PEOPLE :
SELECT MONTH(Date_of_Birth) FROM PEOPLE;
See Also