Thread

Error in rounding of timestamp

Alexander Bodnar <bodnar@malva.com.ua> — 2001-05-05T10:19:18Z

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)