Re: time series data - Mailing list pgsql-sql

Dnia 2004-01-21 09:53, Użytkownik azwa@nc.com.my napisał:
>  time_key integer      not null default nextval('time_seq'::text)> Example of data in time table:> Time_key
yr_id      month_id       month_desc       day_id>      1999       1       Jan       1>      1999       1       Jan
 2>      2000       1       Jan       1
 

Use this integer sequence and interval datatype to get date result:
your_date='1994-01-01'::date+'1 day'::integer * time_key

Now you can do whatever you want with this date - look at Postgresql 
documentation "6.8. Date/Time Functions and Operators" -> "extract"

Regards,
Tomasz Myrta