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

最新推荐文章于 2023-07-19 17:19:06 发布

Zarathusa

最新推荐文章于 2023-07-19 17:19:06 发布

阅读量2.9k

点赞数 2

分类专栏：数据库文章标签： MySQL查询两个日期之间的所有日期

本文链接：https://blog.csdn.net/weixin_44420955/article/details/103456696

版权

数据库专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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 '2019-11-01' 
	AND '2019-12-05' 
ORDER BY
	dates DESC 
	LIMIT 0,
	10

Zarathusa

关注

2
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
MySQL查询两个日期之间的所有日期

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 ALLSELECT 1 UNION ALLSELECT 2 UNI...
复制链接

扫一扫