weekday

Description

Syntax

INT WEEKDAY (DATETIME date)

WEEKDAY函数返回日期的工作日索引值，即星期一为0，星期二为1，星期日为6

参数为Date或者Datetime类型或者可以cast为Date或者Datetime类型的数字

注意WEEKDAY和DAYOFWEEK的区别：

1. +-----+-----+-----+-----+-----+-----+-----+
2. | Sun | Mon | Tues| Wed | Thur| Fri | Sat |
3. +-----+-----+-----+-----+-----+-----+-----+
4. weekday |  6  |  0  |  1  |  2  |  3  |  4  |  5  |
5. +-----+-----+-----+-----+-----+-----+-----+
6. dayofweek |  1  |  2  |  3  |  4  |  5  |  6  |  7  |
7. +-----+-----+-----+-----+-----+-----+-----+

example

1. mysql> select weekday('2019-06-25');
2. +--------------------------------+
3. | weekday('2019-06-25 00:00:00') |
4. +--------------------------------+
5. |                              1 |
6. +--------------------------------+

8. mysql> select weekday(cast(20190625 as date));
9. +---------------------------------+
10. | weekday(CAST(20190625 AS DATE)) |
11. +---------------------------------+
12. |                               1 |
13. +---------------------------------+

keywords

1. WEEKDAY