Re: A tricky sql date question

Yes, PL/SQL should be able to do that for you. Maybe something like this:

declare
  firstdate date;
  lastdate date;
begin

• be sure to do set serveroutput on before running this firstdate := to_date( '01-AUG-2001', 'dd-mon-yyyy' ); lastdate := to_date( '01-AUG-2002', 'dd-mon-yyyy' ); while firstdate <= lastdate loop dbms_output.put_line( to_char( firstdate, 'yyyy mon dd' ) ); firstdate := firstdate + 1; end loop; end;

<seanfour_at_my-deja.com> wrote in message news:8ve1b5$h64$1_at_nnrp1.deja.com...
> Is there any way I can list the dates of all the days between 2 dates
> without looping through a select statement from dual? Basically I want
> to be able to give it, say '01-AUG-2001' and '01-AUG-2002' and have it
> spit back all of the dates between without having to hit the DB 365
> times to do it. Thanks for any help!!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 21 2000 - 13:42:21 CST