Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. 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>