MYSQL DATE_SUB CURDATE 前天时间
-- 前天
SELECT DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 2 DAY), '%Y-%m-%d 00:00:00') AS '前天开始';
SELECT DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 2 DAY), '%Y-%m-%d 23:59:59') AS '前天结束';
-- 前天
SELECT DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 2 DAY), '%Y-%m-%d 00:00:00') AS '前天开始';
SELECT DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 2 DAY), '%Y-%m-%d 23:59:59') AS '前天结束';