Skip site navigation (1) Skip section navigation (2)

Re: timestamp with time zone output incorrect

From: Lew <lew(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp with time zone output incorrect
Date: 2008-04-26 13:26:30
Message-ID: 5eCdnYpp5Y4bsI7VnZ2dnUVZ_vqdnZ2d@comcast.com (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

pgsql-general by date

Next:From: Mircea MoiseiDate: 2008-04-26 14:39:11
Subject: Help! ERROR: could not open relation
Previous:From: Martin MarquesDate: 2008-04-26 12:40:48
Subject: Re: status on pgiomonitor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group