version 11
MONTHNAME (arithmetic_expression)
Description
The MONTHNAME function returns the name of the month for the date passed in the arithmetic_expression.
Example
This example returns the name of the month for each date of birth passed:
SELECT MONTHNAME(Date_of_birth);
See Also