Steve Perry wrote:
>
> 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
Does the IW format mask help at all ???
--
Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"
Received on Sun Jan 10 1999 - 21:15:46 CST
