SELECT SUBDATE(NOW(),DATE_FORMAT(NOW(),"%w")-1) ,NOW(), ADDDATE(now(),7-DATE_FORMAT(NOW(),"%w"))
now()是2017-02-07
结果是
2017-02-06星期1
2017-02-12星期天
SELECT SUBDATE(NOW(),DATE_FORMAT(NOW(),"%w")-1) ,NOW(), ADDDATE(now(),7-DATE_FORMAT(NOW(),"%w"))
now()是2017-02-07
结果是
2017-02-06星期1
2017-02-12星期天