Dnia 2004-01-21 09:53, Użytkownik azwa(at)nc(dot)com(dot)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