Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to generate a list of dates between two dates?

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

From: Vincent Wittlin <vincent.wittlin_at_libertysurf.fr>
Date: Tue, 11 Jan 2000 17:28:35 +0100
Message-ID: <85flf4$gj4$1@jaydee.iway.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US