An illegal date returns a NULL result: : MONTHNAME « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MONTHNAME
mysql>
mysql> SELECT MONTHNAME('9');
+----------------+
| MONTHNAME('9') |
+----------------+
| NULL           |
+----------------+
1 row in set, 1 warning (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: