Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
Дата
Msg-id 54000C6E.3050203@hogranch.com
обсуждение исходный текст
Ответ на Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions  (Vinayak <vinpokale@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On 8/28/2014 10:06 PM, Vinayak wrote:
> Any idea how can we set OS timezone on PostgreSQL?

timestamp with time zone values are stored as the equivalent of UTC and
converted to the client TIME_ZONE setting for display, unless you
specify some other timezone via AT TIME ZONE

I'm not sure why any other behavior would be rational.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

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

Предыдущее
От: Vinayak
Дата:
Сообщение: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions