跳到主要内容
跳到主要内容

MONTHNAME

monthname

description

Syntax

VARCHAR MONTHNAME(DATE)

返回日期对应的月份名字

参数为Date或者Datetime类型

example

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

keywords

MONTHNAME