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