Category Archives: Oracle

How to Convert ISO Weeks to Dates in Oracle

Converting a date to an ISO year-week string is easy in Oracle: >SELECT TO_CHAR(DATE '2012-03-11', 'IYYY-IW') FROM dual; 2012-10 One should think that converting an ISO year-week string back to a date (denoting the first day in this week) should … Continue reading

Posted in Oracle | 19 Comments