Bug #791: Error when inserting timestamp 2002-10-13 00:00:00

Jfferson R. Zuchi (zuchi(at)fusionsoftware(dot)com(dot)br) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Error when inserting timestamp 2002-10-13 00:00:00

Long Description
When I try to insert in a field of the type timestamp value 2002-10-13 00:00:00 occurs this value is modified for 2002-10-12 23:00:00

This was detected in normal conditions of use, with the installation standard of version 7.2.2 running in the platforms Linux (Debian) and FreeBSD 4.4 .

This was the gotten result of a test carried through in my server:

fireball=# \dt
List of relations
Name | Type | Owner
------+-------+----------
test | table | postgres
(1 row)

fireball=# \d test
Table "test"
Attribute | Type | Modifier
-----------+--------------------------+----------
cod | integer | not null
data | timestamp with time zone |
Index: test_pkey

fireball=# insert into test (cod, data) values (1, '2002-10-13 00:00:00');
INSERT 911134 1
fireball=# select * from test ;
cod | data
-----+------------------------
1 | 2002-10-12 23:00:00-03 <-------
(1 row)

fireball=#

Ok, Tanks
Jfferson Zuchi

Sample Code

No file was uploaded with this report