Re: How to generate a list of dates between two dates?

From: Kenneth C Stahl <BlueSax_at_Unforgetable.com>
Date: Tue, 11 Jan 2000 12:08:33 -0500
Message-ID: <387B6391.73FB703A@Unforgetable.com>

Michael Keppler wrote:
>
> Hi everybody !
>
> For a query I need all (possible) dates between two given dates. Is
> there a simple query to generate all of them ? Or do I have to use a
> table with all the dates in it?
>
> Ciao and Thanks, Michael.
>

Declare

    Currdate Date := Null;
    LowDate Const Date := To_Date('20000110','YYYYMMDD');     HiDate Const Date := To_Date('20000322','YYYYMMDD'); Begin

    dbms_output.enable(1000000);
    CurrDate := LowDate;
    While CurrDate <= HiDate Loop

        dbms_output.put_line(to_char(CurrDate,'YYYYMMDD');
        ++Currdate;

    End loop;
End;

Or something like that. Received on Tue Jan 11 2000 - 11:08:33 CST