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: 200801210820.m0L8KMxf015640@wwwmaster.postgresql.org (view raw or flat)
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
Details: 

Hello

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 ?

Regards
Roman

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

week
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
2005.

Responses

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-2014 The PostgreSQL Global Development Group