传入具体的时间后七天:
select
date_add('2020-04-27',interval @i:=@i+1 day) as op_date
from (
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1
) as tmp,(select @i:= -1) t
传入具体的时间的前七天:
select
date_add('2020-04-27',interval @i:=@i-1 day) as op_date
from (
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1
) as tmp,(select @i:= +1) t
说明:
连续多少天根据select 1 union all拼接的个数有关