Skip site navigation (1) Skip section navigation (2)

BUG #3892: Invalid week determination

From: "Roman" <rk(at)infren(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3892: Invalid week determination
Date: 2008-01-21 08:20:22
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3892
Logged by:          Roman
Email address:      rk(at)infren(dot)com
PostgreSQL version: 8.1.4
Operating system:   FC6
Description:        Invalid week determination


Today is 2007-01-21.

select to_char(now(),'yyyyWW')

returns 200803, which is wrong(?)
When I set the date to 2007-01-22 I get 200804 , which is correct.

Is that ok ? Should it not be 200804 also for 2007-01-21 ?


I see in the doc: ( however it does not explain the case )

The number of the week of the year that the day is in. By definition (ISO
8601), the first week of a year contains January 4 of that year. (The
ISO-8601 week starts on Monday.) In other words, the first Thursday of a
year is in week 1 of that year. (for timestamp values only) 

Because of this, it is possible for early January dates to be part of the
52nd or 53rd week of the previous year. For example, 2005-01-01 is part of
the 53rd week of year 2004, and 2006-01-01 is part of the 52nd week of year


pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2008-01-21 09:42:19
Subject: Re: Casting on the limit
Previous:From: Adriaan van OsDate: 2008-01-21 08:17:47
Subject: BUG #3891: Multiple UPDATE doesn't handle UNIQUE constraint correctly

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group