MySQL DAYOFWEEK方法用法及代码示例

例子

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

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

基本用法

要返回当前学生注册日期的工作日索引：

SELECT fname, DAYOFWEEK(day_enrolled)
FROM students;



+----------+-------------------------+
| fname    | DAYOFWEEK(day_enrolled) |
+----------+-------------------------+
| Sky      |                       5 |
| Ben      |                       4 |
| Travis   |                       3 |
| Arthur   |                       6 |
| Benjamin |                       4 |
+----------+-------------------------+

我们可以看到 Sky 在星期四注册，而 Ben 在星期三注册。

要返回周一或周二注册的学生：

SELECT fname, DAYOFWEEK(day_enrolled)
FROM students
WHERE DAYOFWEEK(day_enrolled) IN (2, 3);



+--------+-------------------------+
| fname  | DAYOFWEEK(day_enrolled) |
+--------+-------------------------+
| Travis |                       3 |
+--------+-------------------------+

要从日期时间返回工作日索引：

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



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