Re: date series

Been trying the same thing as well, with no success. I ended up creating a table with a series of dates in it, and using that. Be sure that you use the TRUNC() function, so that you get rid of the fraction of the day within each date.

"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
>
>
Received on Wed May 02 2001 - 14:13:28 CEST