Timestamp field error value

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Timestamp field error value
Date: 2001-03-02 08:29:20
Message-ID: 200103020829.f228TKr17391@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Fabio (f(dot)guidi(at)libero(dot)it) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Timestamp field error value

Long Description
Mandrake 7.2 Postgresql 7.0.2 glibc 2.1.3-18.
If you have a field type timestamp and if you try to insert this value in that field "01/01/2001 10:10:00.00 CET" or a value with the seconds part to "00" postgresql transform that value in "60".
So if you try to select the value you find "01/01/2001 10:10:60.00 CET".

Sample Code

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Lockhart 2001-03-02 13:27:20 Re: Timestamp field error value
Previous Message Tom Lane 2001-03-02 03:25:02 Re: Vacuum analyze problem