Date Time Functions MySQL Tutorial

mysql>
mysql> SELECT MONTHNAME('1989-07-20');
+-------------------------+
| MONTHNAME('1989-07-20') |
+-------------------------+
| July                    |
+-------------------------+
1 row in set (0.02 sec)
mysql>