11.4.14 WEEKDAY(date)函数

11.4.14　WEEKDAY(date)函数

WEEKDAY(date)函数返回日期对应的一周中的索引值。0表示星期一，1表示星期二，以此类推。使用示例如下：

---

mysql> SELECT WEEKDAY(NOW());
+----------------+
| WEEKDAY(NOW()) |
+----------------+
|               6 |
+----------------+
1 row in set (0.00 sec)
mysql> SELECT WEEKDAY('2020-01-01');
+-----------------------+
| WEEKDAY('2020-01-01') |
+-----------------------+
|                      2 |
+-----------------------+
1 row in set (0.00 sec)

---