Retrieve the actual month name: MONTHNAME() : MONTHNAME « Date Time « SQL / MySQL






Retrieve the actual month name: MONTHNAME()

   
mysql>
mysql>
mysql> SELECT MONTHNAME('2004-12-31 23:59:59');
+----------------------------------+
| MONTHNAME('2004-12-31 23:59:59') |
+----------------------------------+
| December                         |
+----------------------------------+
1 row in set (0.00 sec)

   
    
    
  








Related examples in the same category

1.Get the name of the day and month on which they were born, and the day's sequence number within the year of th