Re: Time problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Time problem
Дата
Msg-id 293.1014218373@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Time problem  ("Jaya Swarup" <jayas@bsil.com>)
Список pgsql-admin
"Jaya Swarup" <jayas@bsil.com> writes:
> 3) BUT, when I am retrieving data from the sql query (code) and displaying
> it, it is inexplicably ahead of the System time by exactly 30 mins.

Sure sounds like you are running in some odd time zone.

> 4) I have tried setting the TIME ZONE variable to all possible combinations
> as mentioned in the documentation. But even then if I ask the system to SHOW
> TIME ZONE, it says "TIME ZONE IS UNKNOWN".

This is bizarre.  Exactly what platform are you running on, and exactly
which "possible combinations" have you tried?

            regards, tom lane

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

Предыдущее
От: Pam Wampler
Дата:
Сообщение: How to set time zone permanently
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PL/pgSQL location in RH7.2?