Re: Time is off in PG server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Time is off in PG server
Дата
Msg-id 18014.1093534312@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Time is off in PG server  (Ericson Smith <eric@did-it.com>)
Ответы Re: Time is off in PG server  (Ericson Smith <eric@did-it.com>)
Список pgsql-admin
Ericson Smith <eric@did-it.com> writes:
> I realized I made a mistake in that initial email (should have said 12am
> instead of pm). However, I tried:

>>> set local time zone 'EST5EDT';
> SET
>>> select now();

"set local" was probably not what you wanted to use here.  Per the man page:

    Note that SET LOCAL will appear to have no effect if it is executed outside
    a BEGIN block, since the transaction will end immediately.

            regards, tom lane

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

Предыдущее
От: Ericson Smith
Дата:
Сообщение: Re: Time is off in PG server
Следующее
От: Ericson Smith
Дата:
Сообщение: Re: Time is off in PG server