WEEKDAY
更新时间：2025-10-17
weekday
描述
语法
INT WEEKDAY (DATETIME date)
WEEKDAY 函数返回日期的工作日索引值，即星期一为 0，星期二为 1，星期日为 6
参数为 Date 或者 Datetime 类型或者可以 cast 为 Date 或者 Datetime 类型的数字
注意 WEEKDAY 和 DAYOFWEEK 的区别：
Plain Text
1 +-----+-----+-----+-----+-----+-----+-----+
2 | Sun | Mon | Tues| Wed | Thur| Fri | Sat |
3 +-----+-----+-----+-----+-----+-----+-----+
4 weekday | 6 | 0 | 1 | 2 | 3 | 4 | 5 |
5 +-----+-----+-----+-----+-----+-----+-----+
6dayofweek | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
7 +-----+-----+-----+-----+-----+-----+-----+举例
Plain Text
1mysql> select weekday('2019-06-25');
2+--------------------------------+
3| weekday('2019-06-25 00:00:00') |
4+--------------------------------+
5| 1 |
6+--------------------------------+
7
8mysql> select weekday(cast(20190625 as date));
9+---------------------------------+
10| weekday(CAST(20190625 AS DATE)) |
11+---------------------------------+
12| 1 |
13+---------------------------------+keywords
Plain Text
1WEEKDAY