Steve Martin wrote:
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.
Those are correct. I just looked up New Zealand on
<http://www.worldtimezone.net/wtz020.php>
for example, and it shows NZST as "GMT+12", plus one more for Daylight Saving
Time.
Likewise,
<http://en.wikipedia.org/wiki/Wellington>
lists Wellington's time zone as
Time zone NZST (UTC+12)
- Summer (DST) NZDT (UTC+13)
--
Lew
