Postgres Pro
Downloads
Home   >   mailing lists

Thread: Timestamp field error value

Timestamp field error value

From
pgsql-bugs@postgresql.org
Date:
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
valuewith 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

Re: Timestamp field error value

From
Thomas Lockhart
Date:
> 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
avalue 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".

Get and use the Mandrake RPMs from the ftp.postgresql.org web site. This
is a known problem with the RPMs included in the Mandrake distro, and
their newest builds in cooker should not exhibit the problem.

                       - Thomas