Determining/Setting a server's time zone

Поиск
Список
Период
Сортировка
От Madison Kelly
Тема Determining/Setting a server's time zone
Дата
Msg-id 49C811B2.8030302@alteeve.com
обсуждение исходный текст
Ответы Re: Determining/Setting a server's time zone  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

   How/Where does PostgreSQL set or determine the local time zone?

On my server, I am seeing (+00):

db=> SELECT now();
               now
-------------------------------
  2009-03-23 22:32:47.595491+00
(1 row)


But on my workstation I am seeing (-04):

db=> SELECT now();
               now
-------------------------------
  2009-03-23 18:16:36.591653-04
(1 row)

   The only thing I can think of is that my server is set to believe the
BIOS time is UTC and my workstation is set to EDT. Does PostgreSQL check
this from the host machine?

   For reference, my server is Debian Sarge (4.0) and my workstation is
Ubuntu 8.10.

Thanks!

Madi

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

Предыдущее
От: "Leif B. Kristensen"
Дата:
Сообщение: Re: PostgreSQL versus MySQL for GPS Data
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: text column constraint, newbie question