SELECT DAYOFWEEK(NOW()),WEEKDAY(now()),DATE_FORMAT(NOW(),"%w"),NOW()
now()是星期2
从上面结果来看。
DATE_FORMAT(NOW(),"%w") 2 正好对应
DAYOFWEEK(NOW()) 3 大了
WEEKDAY(now()) 1 小了
(可以理解为DAYOFWEEK长度大于WEEKDAY所以DAYOFWEEK得到为3,WEEKDAY得到为1)
SELECT DAYOFWEEK(NOW()),WEEKDAY(now()),DATE_FORMAT(NOW(),"%w"),NOW()
now()是星期2
从上面结果来看。
DATE_FORMAT(NOW(),"%w") 2 正好对应
DAYOFWEEK(NOW()) 3 大了
WEEKDAY(now()) 1 小了
(可以理解为DAYOFWEEK长度大于WEEKDAY所以DAYOFWEEK得到为3,WEEKDAY得到为1)