timestamp with time zone output incorrect

Поиск
Список
Период
Сортировка
От Steve Martin
Тема timestamp with time zone output incorrect
Дата
Msg-id 48102903.4070403@nec.co.nz
обсуждение исходный текст
Ответы Re: timestamp with time zone output incorrect
Re: timestamp with time zone output incorrect
Список pgsql-general
Hi,

We are having trouble with the output of timestamp with time zone with
versions 8.1.10 and 8.3.1.
It seems reversed, and change over times are incorrect.

timezone for both is:
=> show timezone ;
  TimeZone
-------------
 NZST-12NZDT
(1 row)


Note, change over times for this year is:
Sun Apr 06 02:59:59 NZDT 2008 --> Sun Apr 06 02:00:00 NZST 2008
Sun Sep 28 01:59:59 NZST 2008 --> Sun Sep 28 03:00:00 NZDT 2008


On both versions:
=> select timestamp with time zone '2008-01-01 00:00:00';
      timestamptz
------------------------
 2008-01-01 00:00:00+12

=> select timestamp with time zone '2008-05-01 00:00:00';
      timestamptz
------------------------
 2008-05-01 00:00:00+13
(1 row)


It seems that the time zone off set is reversed.

Also it seems to be using the old change over times.
=> select timestamp with time zone '2008-03-09 01:00:00';
      timestamptz
------------------------
 2008-03-09 01:00:00+12
(1 row)

=> select timestamp with time zone '2008-03-09 03:00:00';
      timestamptz
------------------------
 2008-03-09 03:00:00+13
(1 row)


Checked "postgresql-8.3.1/src/timezone/data/australasia" and the
information here seems correct.

The date on the system (HPUX 11.23) is correct, e.g.
% date
Thu Apr 24 18:22:42 NZST 2008
% echo $TZ
NZST-12NZDT

The database seems to know we are using the New Zealand  time zone.  It
seems to think summer is coming  it is winter.

Any ideas anyone?

Thanks
Steve Martin


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

Предыдущее
От: xaviergxf
Дата:
Сообщение: Postgresql installation - cannot initdb 1
Следующее
От: Martin Marques
Дата:
Сообщение: status on pgiomonitor