mysql 查询两个日期之间的所有日期

SELECT
	a.Date AS dates 
FROM
	(
SELECT
	curdate( ) - INTERVAL ( a.a + ( 10 * b.a ) + ( 100 * c.a ) ) DAY AS Date 
FROM
	(
SELECT
	0 AS a UNION ALL
SELECT
	1 UNION ALL
SELECT
	2 UNION ALL
SELECT
	3 UNION ALL
SELECT
	4 UNION ALL
SELECT
	5 UNION ALL
SELECT
	6 UNION ALL
SELECT
	7 UNION ALL
SELECT
	8 UNION ALL
SELECT
	9 
	) AS a
	CROSS JOIN (
SELECT
	0 AS a UNION ALL
SELECT
	1 UNION ALL
SELECT
	2 UNION ALL
SELECT
	3 UNION ALL
SELECT
	4 UNION ALL
SELECT
	5 UNION ALL
SELECT
	6 UNION ALL
SELECT
	7 UNION ALL
SELECT
	8 UNION ALL
SELECT
	9 
	) AS b
	CROSS JOIN (
SELECT
	0 AS a UNION ALL
SELECT
	1 UNION ALL
SELECT
	2 UNION ALL
SELECT
	3 UNION ALL
SELECT
	4 UNION ALL
SELECT
	5 UNION ALL
SELECT
	6 UNION ALL
SELECT
	7 UNION ALL
SELECT
	8 UNION ALL
SELECT
	9 
	) AS c 
	) a 
WHERE
	a.Date BETWEEN '2022-02-26' 
	AND '2022-03-09' 
ORDER BY
	dates ASC 
	LIMIT 0,
	1000


版权声明:本文为weixin_43652507原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。