Re: ISO weeknumbers

From: sybrandb <sybrandb_at_gmail.com>
Date: Tue, 6 Jan 2009 01:11:49 -0800 (PST)
Message-ID: <88f0af43-2bec-47a1-8ee8-a71fdfaa9826_at_r10g2000prf.googlegroups.com>

On 5 jan, 21:41, "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
Received on Tue Jan 06 2009 - 03:11:49 CST