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

yixian123.com

已于 2023-07-11 12:36:52 修改

阅读量3.1k

点赞数 2

分类专栏： mysql 文章标签： mysql

于 2022-03-09 12:42:57 首次发布

本文链接：https://blog.csdn.net/weixin_43652507/article/details/123374617

版权

mysql 专栏收录该内容

35 篇文章 3 订阅

订阅专栏

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