MONTHNAME(date) returns the full name of the month for date. : MONTHNAME « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MONTHNAME

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>








14.31.MONTHNAME
14.31.1.MONTHNAME(date) returns the full name of the month for date.
14.31.2.SELECT MONTHNAME('1989-07-20');
14.31.3.An illegal date returns a NULL result: