返回日期星期幾的索引 (1 = Sunday, 2 = Monday, ., 7 = Saturday);這些索引值對應于ODBC標準。
mysql> SELECT DAYOFWEEK('1998-02-03'); +---------------------------------------------------------+ |DAYOFWEEK('1998-02-03') | +---------------------------------------------------------+ | 3 | +---------------------------------------------------------+ 1 row in set (0.00 sec)