1、本周数据

SELECT  DATE(subdate(curdate(),date_format(curdate(),'%w')-1)) as thisweek  
union all  
SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 1 day)) as thisweek  
union all  
SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 2 day)) as thisweek  
union all  
SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 3 day)) as thisweek  
union all  
SELECT  DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 4 day)) as thisweek  
union all  
SELECT DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 5 day)) as thisweek  
union all  
SELECT DATE(DATE_ADD(subdate(curdate(),date_format(curdate(),'%w')-1), interval 6 day)) as thisweek

二、上周数据

SELECT  DATE(DATE_SUB(subdate(curdate(),date_format(curdate(),'%w')-1), interval 1 day)) as lastweek  
union all  
SELECT  DATE(DATE_SUB(subdate(curdate(),date_format(curdate(),'%w')-1), interval 2 day)) as lastweek  
union all  
SELECT  DATE(DATE_SUB(subdate(curdate(),date_format(curdate(),'%w')-1), interval 3 day)) as lastweek  
union all  
SELECT  DATE(DATE_SUB(subdate(curdate(),date_format(curdate(),'%w')-1), interval 4 day)) as lastweek  
union all  
SELECT DATE(DATE_SUB(subdate(curdate(),date_format(curdate(),'%w')-1), interval 5 day)) as lastweek  
union all  
SELECT DATE(DATE_SUB(subdate(curdate(),date_format(curdate(),'%w')-1), interval 6 day)) as lastweek  
union all  
SELECT DATE(DATE_SUB(subdate(curdate(),date_format(curdate(),'%w')-1), interval 7 day)) as lastweek
最后修改日期: 2022年12月20日

作者