Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Select dates between two dates

Re: Select dates between two dates

From: Peter McKenzie <pemmck_at_ibm.net>
Date: Wed, 30 Dec 1998 16:49:48 +0800
Message-ID: <76cqbe$27u6@seti.health.wa.gov.au> 





This solution  is a bit rough -



select dates.a_date from


(select trunc(sysdate) - rownum  a_date from any_large_table where rownum <
1000  ) dates


where dates.a_date between to_date('05-JAN-1998','DD-MON-YYYY')
and to_date('05-FEB-1998','DD-MON-YYYY')


Received on Wed Dec 30 1998 - 02:49:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US