Mysql MONTHNAME
From w3cyberlearnings
Contents |
MySQL MONTHNAME Function
This function returns the month name from date or datetime expression
Syntax MONTHNAME
- expre: date or datetime expression
MONTHNAME(expre);
Example 1
mysql> SELECT MONTHNAME('2012-04-22');
+-------------------------+
| MONTHNAME('2012-04-22') |
+-------------------------+
| April |
+-------------------------+
1 row in set (0.00 sec)
Example 2
mysql> SELECT MONTHNAME('2012-12-22');
+-------------------------+
| MONTHNAME('2012-12-22') |
+-------------------------+
| December |
+-------------------------+
1 row in set (0.00 sec)
