date series

From: Jean <ken_jean_at_hotmail.com>
Date: Wed, 2 May 2001 12:47:59 +0200
Message-ID: <9coopd$70d$1_at_serv1.iunet.it>

Hi to all.
[Quoted] [Quoted] I'm developing a web application based on Oracle 8.i database [Quoted] [Quoted] I need a query that outputs date series betweet two dates. [Quoted] [Quoted] For example I have start date 01-05-2001 (DD-MM-YYYY) and end date

[Quoted] 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?
[Quoted] All solutions is appreciated.
[Quoted] Thank a lot in advance.
Bye

JEAN Received on Wed May 02 2001 - 12:47:59 CEST