Re: timestamp with time zone output incorrect

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