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

Re: timestamp with time zone output incorrect

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Steve Martin <steve(dot)martin(at)nec(dot)co(dot)nz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp with time zone output incorrect
Date: 2008-04-26 14:54:55
Message-ID: 20080426145455.GA16188@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, Apr 24, 2008 at 06:30:27PM +1200, 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)

I have no idea what timezone that it. Presumably it switches between
daylight savings and non-daylight savings based on the US rules? I
can't find this timezone anywhere on my system. Perhaps you should try
the timezone Pacific/Auckland to get closer to what you want.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2008-04-26 15:02:44
Subject: Re: Postgresql installation - cannot initdb 1
Previous:From: Mircea MoiseiDate: 2008-04-26 14:39:11
Subject: Help! ERROR: could not open relation

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