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