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

Ok, I had to run this query just to see what it did.

It does indeed return a list of dates for the next 100 days. But How does it do it. This makes no sense to me.

Vincent Wittlin wrote:

> 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 - 11:33:32 CST