oracle中从一个连续时间段中去除想要的的时间，

SELECT to_date('2014-09-15', 'yyyy-mm-dd') + 
     numtodsinterval(rownum - 1, 'day')   as tt
 FROM DUAL 
CONNECT BY ROWNUM <= ((to_date('2014-10-15', 'yyyy-mm-dd') -    to_date('2014-09-30', 'yyyy-mm-dd') + 1) )

 

 

 

 

 select tt, 0 as cc ,0 as count from
(  

SELECT to_date('2014-09-15', 'yyyy-mm-dd') + 
     numtodsinterval(rownum - 1, 'day')   as tt
 FROM DUAL 
CONNECT BY ROWNUM <= ((to_date('2014-10-15', 'yyyy-mm-dd') -    to_date('2014-09-30', 'yyyy-mm-dd') + 1) )

)
WHERE TT not in(to_date('2014-09-17', 'YYYY/MM/DD'),to_date('2014-09-18', 'YYYY/MM/DD')) order by tt desc;