Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions

Поиск
Список
Период
Сортировка
От Vinayak
Тема Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
Дата
Msg-id 1409545329555-5817107.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions  (Steve Crawford <scrawford@pinpointresearch.com>)
Ответы Re: Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Thank you for reply.

The time return by SYSDATE depends on the OS timezone setting while in
PostgreSQL we can set the timezone using 'set time zone..' statement so here
timezone setting depends on DBMS but I think there are not so many systems
that use different timezone settings between DBMS and OS.





-----
Regards,
Vinayak,

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Timezone-difference-between-Oracle-SYSDATE-and-PostgreSQL-timestamp-functions-tp5816851p5817107.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Small fix in PG 9.4b2 - pg_env.sh
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Performance issue with postgres_fdw