Postgres Pro
Downloads
Home   >   mailing lists

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

From Roman Kononov
Subject BUG #4702: refusal to compute date_trunc('week', '0001-12-09 BC');
Date
Msg-id 200903132141.n2DLf2cw019303@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4702: refusal to compute date_trunc('week', '0001-12-09 BC');
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      4702
Logged by:          Roman Kononov
Email address:      kononov@ftml.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error in PLpgSQL with SELECT INTO and composite types
Next
From: Tom Lane
Date:
Subject: Re: BUG #4702: refusal to compute date_trunc('week', '0001-12-09 BC');