MONTHNAME: Get the month name of the date

MONTHDATE(“YYYY-MM-DD”) function takes date and return month name of the date.

mysql> SELECT MONTHNAME("2016-06-21");
+-------------------------+
| MONTHNAME("2016-06-21") |
+-------------------------+
| June                    |
+-------------------------+
1 row in set (0.00 sec)

Previous                                                 Next                                                 Home