Monthname

Description

Syntax

‘VARCHAR MONTHNAME (DATE)’

Month name corresponding to return date

The parameter is Date or Datetime type

example

mysql > select monthname ('2008 -02 -03 00:00');
+----------------------------------+
Monthname ('2008 -02 -03 00:00') 124me;
+----------------------------------+
February 124th;
+----------------------------------+
##keyword
MONTHNAME