WEEKDAY() 週的日數

WEEKDAY(date)

• date 傳入的日期

回傳date (0 = 週一, 1 = 週二, ... 6 = 週日)對應的工作日索引。
mysql> SELECT WEEKDAY('1998-02-03 22:23:00');
-> 1

mysql> SELECT WEEKDAY('1997-11-05');
-> 2