现在有一个问题是:有开始时间、结束时间,怎么查询出这个时间段中的每一天的日期?
如:begintime:2010-10-1,endtime:2010-10-10
结果想得到:
2010-10-1
2010-10-2
2010-10-3
2010-10-4
2010-10-5
2010-10-6
2010-10-7
2010-10-8
2010-10-9
2010-10-10
这个语句怎么写...谢谢啦
如:begintime:2010-10-1,endtime:2010-10-10
结果想得到:
2010-10-1
2010-10-2
2010-10-3
2010-10-4
2010-10-5
2010-10-6
2010-10-7
2010-10-8
2010-10-9
2010-10-10
这个语句怎么写...谢谢啦
SELECT To_Date('2010-10-01','yyyy-mm-dd')+LEVEL-1 FROM dual
CONNECT BY LEVEL<= to_Date('2010-10-10','yyyy-mm-dd')-to_Date('2010-10-01','yyyy-mm-dd')+1 ;
--日期最后指定格式‘yyyy-mm-dd’
SELECT To_Char(To_Date('2010-10-01','yyyy-mm-dd')+LEVEL-1,'yyyy-mm-dd') dt FROM dual
CONNECT BY LEVEL<= to_Date('2010-10-10','yyyy-mm-dd')-to_Date('2010-10-01','yyyy-mm-dd')+1 ;2010-10-01
2010-10-02
2010-10-03
2010-10-04
2010-10-05
2010-10-06
2010-10-07
2010-10-08
2010-10-09
2010-10-10