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 |
+-----------------------------+