SET TIME ZONE problem - Mailing list pgsql-general

From olga@home-medicine-usa.com (Olga)
Subject SET TIME ZONE problem
Date
Msg-id d74f5d28.0208290729.7cc76159@posting.google.com
Whole thread Raw
List 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 by date:

Previous
From: chinhw@hotmail.com (chin)
Date:
Subject: Re: Columns in views
Next
From: Josh Berkus
Date:
Subject: Re: [SQL] Why must the function that a trigger calls return "opaque" ???