11.4.9 MONTH(date)函数
MONTH(date)函数用于返回日期对应的月份,取值返回为1~12。使用示例如下:
mysql> SELECT MONTH(NOW());
+--------------+
| MONTH(NOW()) |
+--------------+
| 12 |
+--------------+
1 row in set (0.00 sec)
MONTH(date)函数用于返回日期对应的月份,取值返回为1~12。使用示例如下:
mysql> SELECT MONTH(NOW());
+--------------+
| MONTH(NOW()) |
+--------------+
| 12 |
+--------------+
1 row in set (0.00 sec)