Horton
Menu

Timestamp field error value

PostgreSQL Bugs List <pgsql-bugs@postgresql.org>

View thread
From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2001-03-02T08:29:20Z
Lists: pgsql-bugs 
Fabio (f.guidi@libero.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