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)