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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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