Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the name of the month from a date.
MONTHNAME( date-expression )
A TIMESTAMP value.
The MONTHNAME function returns a string, even if the result is numeric, such as 2 for the month of February.
The following statement returns the value September:
SELECT MONTHNAME( '1998-09-05' );