MySQLdayofweek()函数

DAYOFWEEK(date)

返回日期星期索引 (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)

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！