monthname

Returns the name of the month for a given date.（返回给定日期的月份名称。）

The date parameter must be of the DATE or DATETIME type.(date 参数必须是 DATE 或 DATETIME 类型。)

语法

VARCHAR MONTHNAME(date)

示例

MySQL > select monthname('2008-02-03 00:00:00');
+----------------------------------+
| monthname('2008-02-03 00:00:00') |
+----------------------------------+
| February                         |
+----------------------------------+

关键词

MONTHNAME, monthname