SELECT MONTHNAME('1989-07-20'); : MONTHNAME « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MONTHNAME
mysql>
mysql> SELECT MONTHNAME('1989-07-20');
+-------------------------+
| MONTHNAME('1989-07-20') |
+-------------------------+
| July                    |
+-------------------------+
1 row in set (0.02 sec)

mysql>
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: