mysql query日期_如何获取mysql中两个日期之间的日期列表select query

最新推荐文章于 2021-02-18 11:17:09 发布

梦游前生

最新推荐文章于 2021-02-18 11:17:09 发布

阅读量131

点赞数

文章标签： mysql query日期

本文链接：https://blog.csdn.net/weixin_34039159/article/details/113984972

版权

SQL 日期范围 ADDDATE函数嵌套查询数据查询

关键词由CSDN通过智能技术生成

尝试：

select * from

(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from

(select 0 i 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) t0,

(select 0 i 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) t1,

(select 0 i 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) t2,

(select 0 i 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) t3,

(select 0 i 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) t4) v

where selected_date between '2012-02-10' and '2012-02-15'

– 日期范围将来将近300年.

[经UrvishAtSynapse建议的修改后更正]