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

BUG #1217: wrong date->number of week conversion

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1217: wrong date->number of week conversion
Date: 2004-08-12 23:33:29
Message-ID: 20040812233329.3426E5A1052@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1217
Logged by:          Romuald Pilitowski

Email address:      rpilitow(at)galera(dot)ii(dot)pw(dot)edu(dot)pl

PostgreSQL version: 7.4

Operating system:   Linux Mandrake 10.0

Description:        wrong date->number of week conversion

Details: 

hi,
  I encountered following problem - executing command:
select to_char(to_date('2003-12-29','YYYY-MM-DD'),'YYYY-IW-DD')
I receive
 2003-01-29 
     (!!)

Frankly speaking I don`t know the adequate calendar ISO norm  in detail, but 
the last days of year shouldn`t be counted as F_I_R_S_T week of that year. I 
expected PostgreSQL rather to return 2003-53-29. 

Some extra details about my OS:

uname -a
Linux computer 2.6.3-4mdk #1 Tue Mar 2 07:26:13 CET 2004 i586 unknown 
unknown GNU/Linux 

SELECT version()
PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 
20030222 (Red Hat Linux 3.2.2-5 


Romuald Pilitowski, Poland



Responses

pgsql-bugs by date

Next:From: Zeki MokhtarzadaDate: 2004-08-13 02:53:20
Subject: Primary key duplicates
Previous:From: Aled MorrisDate: 2004-08-12 21:53:52
Subject: Errors should go to the Windows event log

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