insert of date is wrong - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject insert of date is wrong
Date
Msg-id 200107241821.f6OIL2n49564@hub.org
Whole thread Raw
Responses Re: insert of date is wrong
List pgsql-bugs
Marcos (tanzarian@bol.com.br) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
insert of date is wrong

Long Description
when I insert the date '1914/01/01' in a column with the 'date' format, the table returns the value '1913/12/31'



Sample Code
insert into d values ('1914/01/01');
select * from d;
this command return : '1913/12/31'

No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: real or float4 '=' operator is broken in 7.1.2
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: pg_dump doesn't handle CREATE FUNCTIONs well