今天需要核对数据,需要用到指定日期段间的每一具体日期,遂在群里询问,但没有回应,于是乎自己编写如下(也就是号段选择的问题):
——————————————————————————————————————
select a.startdate as startdate,
startdate+b.dis- 1 yallonking_date,
a.enddate
from (select to_date( '20120501', 'yyyymmdd' ) as startdate,to_date('20120531' , 'yyyymmdd') as enddate from dual) a,( select rownum dis from
( select max (enddate-startdate)+2 gap
from (select to_date( '20120501', 'yyyymmdd' ) as startdate,to_date('20120531' , 'yyyymmdd') as enddate from dual)) connect by rownum =startdate+b.dis- 1;
startdate+b.dis- 1 yallonking_date,
a.enddate
from (select to_date( '20120501', 'yyyymmdd' ) as startdate,to_date('20120531' , 'yyyymmdd') as enddate from dual) a,( select rownum dis from
( select max (enddate-startdate)+2 gap
from (select to_date( '20120501', 'yyyymmdd' ) as startdate,to_date('20120531' , 'yyyymmdd') as enddate from dual)) connect by rownum =startdate+b.dis- 1;
——————————————————————————————————————
记录于此,以飨后人... ...
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26143577/viewspace-731570/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26143577/viewspace-731570/