Thread

1. Timestamp field error value

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-03-02T08:29:20Z

   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
   
   
   

2. Re: Timestamp field error value

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 2001-03-02T13:27:20Z

   > 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".
   
   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