Some timestamp problems
От | Vilson farias |
---|---|
Тема | Some timestamp problems |
Дата | |
Msg-id | 0ad501c24f96$900a5480$98a0a8c0@dgtac обсуждение исходный текст |
Список | 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.farias@digitro.com.br Tel.: +55 48 281 7158 ICQ 11866179
В списке pgsql-admin по дате отправления: