| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select dates between two dates
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
|  |  |