Re: date series

I found a good solution.
It is:
select to_date(t.startdate,'DD/MM/YYYY') AS tstamp

from TABLE(cast ( ORDSYS.Calendar.GenDateRangeTab(

ORDSYS.ORDTCalendar(

0,

'BusinessWeek',

4,

ORDSYS.ORDTPattern(

ORDSYS.ORDTPatternBits(1,1,1,1,1,1,1),

TO_DATE('01/04/2001','DD/MM/YYYY')), TO_DATE('01/04/2001','DD/MM/YYYY'), TO_DATE('30/04/2001','DD/MM/YYYY'), ORDSYS.ORDTExceptions(),

ORDSYS.ORDTExceptions()

)) as ORDSYS.ORDTDateRangeTab)) t

"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 - 16:37:26 CEST