MySQL WEEKDAY方法用法及代碼示例

例子

考慮下表有關一些學生的信息：

可以使用此處的代碼創建上述示例表。

基本用法

要返回當前學生注冊日期的工作日索引：

SELECT fname, WEEKDAY(day_enrolled)
FROM students;



+----------+-----------------------+
| fname    | WEEKDAY(day_enrolled) |
+----------+-----------------------+
| Sky      |                     3 |
| Ben      |                     2 |
| Travis   |                     1 |
| Arthur   |                     4 |
| Benjamin |                     2 |
+----------+-----------------------+

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

要返回周一或周二注冊的學生：

SELECT fname, WEEKDAY(day_enrolled)
FROM students
WHERE WEEKDAY(day_enrolled) IN (0, 1);



+--------+-----------------------+
| fname  | WEEKDAY(day_enrolled) |
+--------+-----------------------+
| Travis |                     1 |
+--------+-----------------------+

要從日期時間返回工作日索引：

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



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