Re: date series

From: Dave Fowler <d.fowler_at_smmj.com>
Date: Wed, 02 May 2001 14:08:10 GMT
Message-ID: <exUH6.1669$Cq3.153365@newsread1.prod.itd.earthlink.net>

Jean,
Create a table (calendar) with everyday of year even for multiple years. This time dimension table could also have other columns of denormal info. day name, quarter,week day flag,....
all of which can be derived with date format masks. this table is also useful for star schema apps. DSS apps.
See Ralph Kimball books on time dimension data.

"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 - 09:08:10 CDT