select a.click_date
from (
SELECT curdate() as click_date
union all
SELECT date_sub(curdate(), interval 1 day) as click_date
union all
SELECT date_sub(curdate(), interval 2 day) as click_date
union all
SELECT date_sub(curdate(), interval 3 day) as click_date
union all
SELECT date_sub(curdate(), interval 4 day) as click_date
union all
SELECT date_sub(curdate(), interval 5 day) as click_date
union all
SELECT date_sub(curdate(), interval 6 day) as click_date
) a
curdate()格式为2018-08-08 可使用字符串代替 当然返回的时间格式也是yyyy-MM-dd
可使用DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 6 DAY),'%Y%m%d') 返回的格式20180808. 后边是格式,可相对应找到相应的格式