Date: Mon, 05 Jan 2009 20:41:16 GMT
The IW format string returns the ISO week number
Week of year (1-52 or 1-53) based on the ISO standard.
I'm confused by this. When would you get week 53? For example, when running this against the last week of 2008 (using 184.108.40.206 SE) , it switches from week 52 to week 1 while still in December.
select to_char(to_date('20081228','yyyymmdd') ,'IW') from dual;
select to_char(to_date('20081229','yyyymmdd') ,'IW') from dual;
-- Terry DykstraReceived on Mon Jan 05 2009 - 14:41:16 CST