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