MySQL YEAR方法用法及代碼示例

例子

考慮下表有關一些學生的信息：

可以使用此處的代碼創建上述示例表。

基本用法

要返回當前學生入學的年份：

SELECT YEAR(day_enrolled)
FROM students;



+--------------------+
| YEAR(day_enrolled) |
+--------------------+
|               2015 |
|               2016 |
|               2018 |
|               2016 |
|               2014 |
+--------------------+

返回2016之前注冊的學生：

SELECT *
FROM students
WHERE YEAR(day_enrolled) < 2016;



+------------+----------+--------+--------------+------+----------+
| student_id | fname    | lname  | day_enrolled | age  | username |
+------------+----------+--------+--------------+------+----------+
|          1 | Sky      | Towner | 2015-12-03   |   17 | stowner1 |
|          5 | Benjamin | Town   | 2014-01-01   |   17 | btown5   |
+------------+----------+--------+--------------+------+----------+

從日期時間返回年份：

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



+-----------------------------+
| YEAR('2020-04-12 06:05:55') |
+-----------------------------+
|                        2020 |
+-----------------------------+