Error in rounding of timestamp

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 12:22:51
Message-ID: 004401c0d55e$26161f40$0f00200a@alex
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

djs=# SELECT version();
version
-----------------------------------------------------------
PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

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)

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-05-05 12:44:48 Error in rounding of timestamp
Previous Message Alexander Bodnar 2001-05-05 10:19:18 Error in rounding of timestamp