Re: timestamp with time zone output incorrect

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: timestamp with time zone output incorrect
Дата
Msg-id 20080426145455.GA16188@svana.org
обсуждение исходный текст
Ответ на timestamp with time zone output incorrect  (Steve Martin <steve.martin@nec.co.nz>)
Ответы Re: timestamp with time zone output incorrect
Список 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@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Martin Marques
Дата:
Сообщение: Re: status on pgiomonitor
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Postgresql installation - cannot initdb 1