MySQL DAY方法用法及代码示例

例子

考虑下表有关一些学生的信息：

可以使用此处的代码创建上述示例表。

基本用法

要返回当前学生注册的日期：

SELECT fname, DAY(day_enrolled)
FROM students;



+----------+-------------------+
| fname    | DAY(day_enrolled) |
+----------+-------------------+
| Sky      |                 3 |
| Ben      |                20 |
| Travis   |                14 |
| Arthur   |                 1 |
| Benjamin |                 1 |
+----------+-------------------+

返回第一天入学的学生：

SELECT *
FROM students
WHERE DAY(day_enrolled) = 1;



+------------+----------+-------+--------------+------+----------+
| student_id | fname    | lname | day_enrolled | age  | username |
+------------+----------+-------+--------------+------+----------+
|          4 | Arthur   | David | 2016-04-01   |   16 | adavid4  |
|          5 | Benjamin | Town  | 2014-01-01   |   17 | btown5   |
+------------+----------+-------+--------------+------+----------+

从日期时间返回日期：

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



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