MySQL MONTH方法用法及代码示例

例子

假设我们想返回当前学生入学的月份：

SELECT MONTH(day_enrolled)
FROM students;



+---------------------+
| MONTH(day_enrolled) |
+---------------------+
|                  12 |
|                   4 |
|                   8 |
|                   4 |
|                   1 |
+---------------------+
5 rows in set (0.00 sec)

我们可以将搜索范围缩小到仅六月之前注册的学生：

SELECT *
FROM students
WHERE MONTH(day_enrolled) < 6;



+------------+----------+-------+--------------+------+----------+
| student_id | fname    | lname | day_enrolled | age  | username |
+------------+----------+-------+--------------+------+----------+
|          2 | Ben      | Davis | 2016-04-20   |   19 | bdavis2  |
|          4 | Arthur   | David | 2016-04-01   |   16 | adavid4  |
|          5 | Benjamin | Town  | 2014-01-01   |   17 | btown5   |
+------------+----------+-------+--------------+------+----------+
3 rows in set (0.00 sec)

我们不一定要从表中选择：

SELECT MONTH('2020-04-12-06-05-55');



+------------------------------+
| MONTH('2020-04-12-06-05-55') |
+------------------------------+
|                            4 |
+------------------------------+
1 row in set (0.00 sec)