mysql 查询本周 与上周(星期一至星期日)
本周
select
*
from t_xazr_jjr_invite_week_rank
where is_delete = 0 and
YEARWEEK(date_format(create_time, ‘%Y-%m-%d’),1) = YEARWEEK(now(),1)
上周
select
*
from t_xazr_jjr_invite_week_rank
where is_delete = 0 and YEARWEEK(date_format(create_time, ‘%Y-%m-%d’),1) = YEARWEEK(now(),1)-1
select subdate(curdate(),date_format(curdate(),’%w’)-1)
select subdate(curdate(),date_format(curdate(),’%w’)-7)