MONTHNAME(date)

MySQL 8.4

Returns the full name of the month for date. The language used for the name is controlled by the value of the lc_time_names system variable (Section 12.16, “MySQL Server Locale Support”). Returns NULL if date is NULL.

Syntax

MYSQL

SELECT MONTHNAME('2008-02-03');
'February'

Examples

Example

MYSQL

SELECT MONTHNAME('2008-02-03');
'February'