[BUGS] Error in rounding of timestamp

2001-05-07 Thread Alexander Bodnar
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 "Da

[BUGS] Error in rounding of timestamp

2001-05-07 Thread Alexander Bodnar
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 l

[BUGS] Error in rounding of timestamp

2001-05-05 Thread pgsql-bugs
Alexander Bodnar ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Error in rounding of timestamp Long Description djs=# SELECT version(); version