我要上周的所有数据。我用过
SELECT id FROM tbl
WHERE date >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAY
AND date < curdate() - INTERVAL DAYOFWEEK(curdate())-1 DAY 但是,当我的一周以“星期一”开始时,它就不起作用了。
我该怎么办?
发布于 2012-09-19 19:45:09
然后像这样改变
$lastweek = unix_to_human(time("Y-m-d H:i:s") - (7 * 24 * 60 * 60), TRUE, 'us');
SELECT id FROM tbl
WHERE date >= curdate() - $lastweek
AND date < curdate() - $lastweek 发布于 2012-09-19 19:46:14
试一试
SELECT id FROM tbl
WHERE YEARweek(date) = YEARweek(curdate())发布于 2012-09-19 21:40:04
SELECT id FROM tbl WHERE date >= CURDATE() - INTERVAL (WEEKDAY(CURDATE())+7) DAY AND date < CURDATE() - INTERVAL (WEEKDAY(CURDATE())) DAY 我试过了,它对我很管用。
https://stackoverflow.com/questions/12493995
复制相似问题