Re: [SQL] time series data

help me to solve the above problem . thanks in advance. Tomasz Myrta <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/27/2004 10:56 AM CET         To:        [EMAIL PROTECTED]         cc:        [EMAIL PROTECTED]         Subject:        Re: [SQL] time series data Dnia 2004-01-2

Re: [SQL] time series data

Dnia 2004-01-27 02:42, Użytkownik [EMAIL PROTECTED] napisał: Hi, thanks for the info..btw can u pls explain a little bit detail since i can't get thru yr solution. thanks in advance insert into time_table (time_key,year_id,month_id,month_desc,day_id) select newid, extract('year' from you

Re: [SQL] time series data

Hi,    thanks for the info..btw can u pls explain a little bit detail since i can't get thru yr solution. thanks in advance Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał: > Use this integer sequence and interval datatype to get date result: > your_date='1994-01-01'::date+'1 day'::i

Re: [SQL] time series data

Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał: Use this integer sequence and interval datatype to get date result: your_date='1994-01-01'::date+'1 day'::integer * time_key ^^^ Sorry, use interval here. Regards, Tomasz Myrta -

Re: [SQL] time series data

Dnia 2004-01-21 09:53, Użytkownik [EMAIL PROTECTED] napisał: time_key integer not null default nextval('time_seq'::text) > Example of data in time table: > Time_keyyr_idmonth_idmonth_desc day_id > 1999 1 Jan 1 > 1999 1 Jan 2 > 2000