How to convert a week-year string into a date
696834Jan 26 2010 — edited Jan 26 2010Hi
How do I turn a string with a iw-yyyy (week-year) representation into a date type?
Example:
DECLARE
d varchar(200);
da date;
BEGIN
d := TO_CHAR(sysdate, 'iw-yyyy');
DBMS_OUTPUT.PUT_LINE(d);
-- THIS FAILS
da := to_date(d, 'IW-YYYY');
END;
Regards
Runski