Re: date series

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 2 May 2001 14:26:22 +0200
Message-ID: <tevv3ee9m2c69c@beta-news.demon.nl>

"Jean" <ken_jean_at_hotmail.com> wrote in message news:9coopd$70d$1_at_serv1.iunet.it...
> Hi to all.
> I'm developing a web application based on Oracle 8.i database
> I need a query that outputs date series betweet two dates.
> For example I have start date 01-05-2001 (DD-MM-YYYY) and end date
> 07-05-2001 (DD-MM-YYYY) and the query results must be
> 01-05-2001
> 02-05-2001
> 03-05-2001
> 04-05-2001
> 05-05-2001
> 06-05-2001
> 07-05-2001
> I say that it can be possible using calendar functions but I'm not able to
> use it.
> Can anyone help me?
> All solutions is appreciated.
> Thank a lot in advance.
> Bye
>
> JEAN
>
>

Other than a series
select
from dual
union
select
from dual
union
select from dual

there's no real solution.

Could you please refrain from crossposting?

Regards,

Sybrand Bakker, Oracle DBA Received on Wed May 02 2001 - 07:26:22 CDT