Re: NZDT Question

Поиск
Список
Период
Сортировка
Искать
От
Mike C
Тема
Re: NZDT Question
Дата
Msg-id
bd0eabd0709252042i65de73f7v2b45cfabf31d1ca5@mail.gmail.com
Ответ на
Re: NZDT Question (Tom Lane)
Список
Дерево обсуждения
NZDT Question "Mike C" <smith.not.western@gmail.com>
Re: NZDT Question Tom Lane <tgl@sss.pgh.pa.us>
Re: NZDT Question "Mike C" <smith.not.western@gmail.com> 
On 9/26/07, Tom Lane  wrote:
>
> regression=# set timezone to 'Pacific/Auckland';
> SET
> regression=# select '2007-10-01 06:12:40.097244+12'::timestamptz;
>           timestamptz
> -------------------------------
>  2007-10-01 07:12:40.097244+13
> (1 row)
>
> What have you got "timezone" set to?  Did you remember to restart
> the postmaster after updating?

Aha! Thanks... when I ran set timezone, it did not recognize
'Pacific/Auckland'. I hadn't installed share/timezone in correct
location. Works great now!

Cheers,

Mike
В списке pgsql-general по дате отправления
Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: NZDT Question
Следующее
От: David Fetter
Дата:
FAQ