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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
