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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Zeki Mokhtarzada | 2004-08-13 02:53:20 | Primary key duplicates |
Previous Message | Aled Morris | 2004-08-12 21:53:52 | Errors should go to the Windows event log |