Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

MONTHNAME(date) 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. mysql> mysql> SELECT MONTHNAME('1998-02-05'); +-------------------------+ | MONTHNAME('1998-02-05') | +-------------------------+ | February                | +-------------------------+ 1 row in set (0.00 sec) mysql>