On Thu, Apr 24, 2008 at 06:30:27PM +1200, Steve Martin wrote:
> 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 ;
> (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
pgsql-general by date
|Next:||From: Martijn van Oosterhout||Date: 2008-04-26 15:02:44|
|Subject: Re: Postgresql installation - cannot initdb 1|
|Previous:||From: Mircea Moisei||Date: 2008-04-26 14:39:11|
|Subject: Help! ERROR: could not open relation|