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

Try This :

Select sysdate + Rownum from cat,cat,cat where rownum <= 100;

Michael Keppler <Michael.Keppler_at_gmx.de> a écrit dans le message : 85fjn5$b6s_at_TGZ3...
> 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.
>
> --
> Michael Keppler, MCSE, MCP+I
> IT logic GbR
> Michael.Keppler_at_gmx.de
>
>
>
Received on Tue Jan 11 2000 - 10:28:35 CST