Some timestamp problems

From: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Some timestamp problems
Date: 2002-08-29 19:59:18
Message-ID: 0ad501c24f96$900a5480$98a0a8c0@dgtac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

I found some strange behaviour in 7.1.2. Is it the same thing on 7.2.2 ?

I don't know if it's a psql bug, but I would like to report it anyway

bxs=# \d test2
Table "test2"
Attribute | Type | Modifier
------------------+--------------------------+----------
x | integer |
apagar_menor_que | timestamp with time zone |

bxs=# insert into test2 values(1, '2111-10-01 04:23:59.999');
INSERT 259672 1
bxs=# insert into test2 values(2, '20001-10-01 04:23:50');
INSERT 259673 1
bxs=# insert into test2 values(3, '20001-10-01 04:23:59');
INSERT 259674 1
bxs=# insert into test2 values(4, '20001-10-01 04:23:59.99');
INSERT 259675 1
bxs=# insert into test2 values(5, '20001-10-01 04:23:59.999');
INSERT 259676 1
bxs=# insert into test2 values(6, '20001-10-01 04:23:59.998');
INSERT 259677 1
bxs=# SELECT * FROM test2;
x | apagar_menor_que
---+------------------------
1 | 2111-10-01 04:23:60.00
2 | 20001-10-01 04:2350
3 | 20001-10-01 04:2359
4 | 20001-10-01 04:2359.99
5 | 20001-10-01 04:2360.00
6 | 20001-10-01 04:2360.00
(6 rows)

bxs=#

Best regards from Brazil,

----------------------------------------------------------------------------
----
José Vilson de Mello de Farias
Software Engineer

Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson(dot)farias(at)digitro(dot)com(dot)br
Tel.: +55 48 281 7158
ICQ 11866179

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2002-08-29 20:02:01 Re: Silencing NOTICEs in Perl Pg
Previous Message Bruno Wolff III 2002-08-29 19:22:51 Re: Silencing NOTICEs in Perl Pg