SET TIME ZONE problem

Поиск
Список
Период
Сортировка
От olga@home-medicine-usa.com (Olga)
Тема SET TIME ZONE problem
Дата
Msg-id d74f5d28.0208290729.7cc76159@posting.google.com
обсуждение исходный текст
Список pgsql-general
Hi,
I noticed that the following query "select now()" returns wrong time
(3 hours before the machine time).
So I changed the timezone to 'gct-3' (BTW, why -3 hours, I was sure
that it should be +3 hours).
After this changed, the now() function returned right time and
everything was perfect.
But on the next day the timezone returned to be default ('gct+0').
I changed it one more time, but my change worked only at the same day,
and the day after it was wrong.

Does anybody know what is the problem?

Thanks in advance,
Olga

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

Предыдущее
От: chinhw@hotmail.com (chin)
Дата:
Сообщение: Re: Columns in views
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [SQL] Why must the function that a trigger calls return "opaque" ???