如何在mysql select查询中获取两个日期之间的日期列表 [英] How to get list of dates between two dates in mysql select query

问题描述

我希望日期列表通过选择查询位于两个日期之间.例如:

I want list of dates lies between two dates by select query. For example:

如果我给出"2012-02-10"和"2012-02-15"，则需要结果.

If i give '2012-02-10' and '2012-02-15' I need the result.

date      
----------
2012-02-10
2012-02-11
2012-02-12
2012-02-13
2012-02-14
2012-02-15 

我如何得到?

推荐答案

尝试:

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年.

-for date ranges up to nearly 300 years in the future.

[根据UrvishAtSynapse的建议修改后纠正.]

[Corrected following a suggested edit by UrvishAtSynapse.]

这篇关于如何在mysql select查询中获取两个日期之间的日期列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！