SQL获取未来7天的日期列表

SQL语句

123

-- 获取未来7天日期和星期x
select *,CONCAT(day_name,'(',week_name,')') day_week_name
FROM
(
select DATE_FORMAT(weekday.day1,'%Y-%m-%d') day_name,
(
CASE DAYOFWEEK(weekday.day1)
    WHEN 1 THEN '星期日'
    WHEN 2 THEN '星期一'
    WHEN 3 THEN '星期二'
    WHEN 4 THEN '星期三'
    WHEN 5 THEN '星期四'
    WHEN 6 THEN '星期五'
    WHEN 7 THEN '星期六'
    ELSE '未知'
END
) week_name 
FROM
(
select DATE_SUB(NOW(),INTERVAL -1 DAY) day1 union
select DATE_SUB(NOW(),INTERVAL -2 DAY) day2 union
select DATE_SUB(NOW(),INTERVAL -3 DAY) day3 UNION
select DATE_SUB(NOW(),INTERVAL -4 DAY) day4 UNION
select DATE_SUB(NOW(),INTERVAL -5 DAY) day5 UNION
select DATE_SUB(NOW(),INTERVAL -6 DAY) day6 UNION
select DATE_SUB(NOW(),INTERVAL -7 DAY) day7
) weekday
) table1