1、DAYOFWEEK(date) 1 2 SELECT DAYOFWEEK(‘2016-01-16') SELECT DAYOFWEEK(‘2016-01-16 00:00:00') 1 -> 7 (表示返回日期date是星期幾,記住:星期天=1,星期一=2, ... 星期六=7) 2、WEEKDAY(date) 1 2 SELECT WEEKDAY(‘2016-01-16') SELECT WEEKDAY(‘2016-01-16 00:00:00') 1 -...
www.dbjr.com.cn/article/1358...htm 2025-6-2