How to convert YYYYWW to date

From: Steve Perry <sperry_at_sprynet.com>
Date: Fri, 08 Jan 1999 08:39:48 -0800
Message-ID: <369634D4.A56C4AD7@sprynet.com>

I have a table that has  a column year_week stored as a number. Is there an easy way to convert this to date.
For example: 199901 would be converted to jan-02-1999 ( the last day of the week for week 1 of 1999)
19902 would be jan-09-1999...

I thought it would be pretty easy using the to_char and to_date, but it's more of a problem than I thought.

Can somebody get me started in the right direction.

Thanks,
Steve Received on Fri Jan 08 1999 - 10:39:48 CST