Re: ISO weeknumbers

From: ddf <oratune_at_msn.com>
Date: Mon, 5 Jan 2009 13:24:11 -0800 (PST)
Message-ID: <d492a131-d53f-4c29-988c-85cc78022570_at_r40g2000yqj.googlegroups.com>

On Jan 5, 2:41 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> The IW format string returns the ISO week number
>
> IW
>  No
>      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 9.2.0.7 SE) , it switches
> from week 52 to week 1 while still in December.
>
> select to_char(to_date('20081228','yyyymmdd') ,'IW') from dual;> 52
>
> select to_char(to_date('20081229','yyyymmdd') ,'IW') from dual;
>
> > 01
>
> --
> Terry Dykstra

At the end of this year:

SQL> select to_char(to_date('20091229','yyyymmdd') ,'IW') from dual;

TO

--
53

SQL>


David Fitzjarrell

Received on Mon Jan 05 2009 - 15:24:11 CST