| From: | "Alexander Bodnar" <bodnar(at)malva(dot)com(dot)ua> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Error in rounding of timestamp |
| Date: | 2001-05-05 10:19:18 |
| Message-ID: | 001b01c0d54c$e40ad5c0$0f00200a@alex |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
INSERT INTO "ObjectLog1" VALUES (1, '2001-05-02 13:48:59.999', 0, 10, 1, 1,
9, 0, 0, 0, 0);
djs=# select "Date" from "ObjectLog1";
Date
---------------------------
2001-05-02 13:48:60.00+03
(1 row)
------------------->13:48:60.00 !!!!!!
It supposed to be 13:49:00.00
Also this bug leads to invalid result of backup-restore procedure.
Restore reports "Bad timestamp format"
Also this bug enforces ODBC error message.
djs=# select date_trunc('second', "Date"), date_part('milliseconds', "Date")
from "ObjectLog1";
date_trunc | date_part
------------------------+------------------
2001-05-02 13:48:59+03 | 999.000000000002
(1 row)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Bodnar | 2001-05-05 12:22:51 | Error in rounding of timestamp |
| Previous Message | Tom Lane | 2001-05-05 04:10:53 | Re: Build fails for pl/tcl on OpenBSD |