| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | f(dot)guidi(at)libero(dot)it, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Timestamp field error value |
| Date: | 2001-03-02 13:27:20 |
| Message-ID: | 3A9F9FB8.BD55D571@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jiri Skrivanek | 2001-03-02 16:50:42 | Driver bug (DECIMAL column issue) |
| Previous Message | pgsql-bugs | 2001-03-02 08:29:20 | Timestamp field error value |