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