BUG #4702: refusal to compute date_trunc('week', '0001-12-09 BC');

From: "Roman Kononov" <kononov(at)ftml(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4702: refusal to compute date_trunc('week', '0001-12-09 BC');
Date: 2009-03-13 21:41:02
Message-ID: 200903132141.n2DLf2cw019303@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: 4702
Logged by: Roman Kononov
Email address: kononov(at)ftml(dot)net
PostgreSQL version: 8.3.6 and older
Operating system: GNU/Linux x86_64
Description: refusal to compute date_trunc('week', '0001-12-09 BC');
Details:

test=# select date_trunc('week','0001-12-09 BC'::timestamp);
ERROR: cannot calculate week number without year information

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-03-13 21:42:11 Re: Error in PLpgSQL with SELECT INTO and composite types
Previous Message Heikki Linnakangas 2009-03-13 20:44:54 Error in PLpgSQL with SELECT INTO and composite types