MySQL查询最近1000天的日期

文章目录

直接看SQL

select DATE(DATE_SUB(CURDATE(),INTERVAL rn day)) as date from
(SELECT ROW_NUMBER() over() as rn
 FROM 
(SELECT 0 AS N UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) a
,(SELECT 0 AS N UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) b
,(SELECT 0 AS N UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) c
) t

返回结果

2023-06-26
2023-06-25
2023-06-24
2023-06-23
...省略N行
2020-10-03
2020-10-02
2020-10-01
2020-09-30