Getting Names for Months and Days : Introduction « Date Time Functions « MySQL Tutorial

There are two functions that can be used to look up month and day names for a given date:



MONTHNAME(date) can be used to obtain the name of the month in which date occurs as a string

mysql> SELECT MONTHNAME('0-2-1');
| MONTHNAME('0-2-1') |
| February           |
1 row in set (0.00 sec)


14.1.1.Date and Time Functions
14.1.2.Extraction Functions
14.1.3.Changing Date Values
14.1.4.Getting Day Information
14.1.5.Getting Names for Months and Days
14.1.6.Extracting Years, Quarters, Months, and Weeks
14.1.7.Current Date and Time
14.1.8.Days Since 1 A.D.
14.1.9.Seconds Since the Beginning of the Day