BUG #2366: Timestamptz data type is inaccurate

Поиск
Список
Период
Сортировка
От Christian Holtje
Тема BUG #2366: Timestamptz data type is inaccurate
Дата
Msg-id 200603311638.k2VGcnJR097341@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2366: Timestamptz data type is inaccurate  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: BUG #2366: Timestamptz data type is inaccurate  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2366
Logged by:          Christian Holtje
Email address:      christian.holtje@timesys.com
PostgreSQL version: 7.4.8
Operating system:   Ubuntu 5.10
Description:        Timestamptz data type is inaccurate
Details:

I don't know what's going on, but basically, for some dates timestamptz is
loosing parts of the date/time (like the timezone, etc.)

db=# select '2076-03-30 19:57:05-05'::timestamptz;
     timestamptz
---------------------
 2076-03-31 00:57:05
(1 row)

db=# select '2037-03-30 19:57:05-05'::timestamptz;
      timestamptz
------------------------
 2037-03-30 20:57:05-04
(1 row)

db=# select '2006-03-30 19:57:05-05'::timestamptz + '100 years'::interval;
      ?column?
---------------------
 2106-03-30 19:57:05
(1 row)

Note that the hours, minutes or timezone aren't correct.  I tried the last
one to make sure it's not due to the parser.

Thanks for your help.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Bujic Nikola"
Дата:
Сообщение: BUG #2365: can't install
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #2366: Timestamptz data type is inaccurate