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

keyword

WEEKDAY