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
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 |