Обсуждение: Bug #791: Error when inserting timestamp 2002-10-13 00:00:00

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

pgsql-bugs@postgresql.org writes:
>   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 

(a) what timezone are you running in?

(b) does it happen on only that date?  If so, is that a daylight-savings
transition day in your timezone?

            regards, tom lane