Jéfferson R. Zuchi (zuchi@fusionsoftware.com.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-1223:00:00
This was detected in normal conditions of use, with the installation standard of version 7.2.2 running in the
platformsLinux (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
Jéfferson Zuchi
Sample Code
No file was uploaded with this report