| From: | olga(at)home-medicine-usa(dot)com (Olga) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | SET TIME ZONE problem |
| Date: | 2002-08-29 15:29:02 |
| Message-ID: | d74f5d28.0208290729.7cc76159@posting.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Patnude | 2002-08-29 15:35:42 | Why must the function that a trigger calls return "opaque" ??? |
| Previous Message | Ben-Nes Michael | 2002-08-29 15:15:50 | Re: join problem or maybe group :( |