| From: | jason_priebe(at)yahoo(dot)com (Jason Priebe) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | more timeofday() and "set time zone" weirdness |
| Date: | 2003-08-13 15:04:14 |
| Message-ID: | ff375b78.0308130704.27b8c30b@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I posted earlier with a very complex example. This simple one
gets to the point much faster. timeofday() seems to behave
inconsistently when the timezone is set with "GMT+X" notation.
foo=> select cast(timeofday() as timestamp with time zone); set time
zone 'GMT+4'; select cast(timeofday() as timestamp with time zone);
timeofday
-------------------------------
2003-08-13 11:01:26.502064-04
(1 row)
SET VARIABLE
timeofday
-------------------------------
2003-08-13 07:01:26.503328-04
(1 row)
I am currently 4 hours behind GMT. The first timestamp reflects
the correct time. After setting the time zone to "GMT+4", I get
a time value that is 4 hours too early. If I were to instead
use "America/New_York" for the time zone, I would not have this
problem. Unfortunately, I cannot use such notation under Cygwin.
BTW -- I am seeing this problem with version 7.2.3 under RH Linux
version 7.3.
Jason Priebe
jason_priebe(at)yahoo(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-08-13 15:25:33 | Re: How to prevent vacuum and reindex from deadlocking. |
| Previous Message | Teodor Sigaev | 2003-08-13 14:59:54 | Re: Tsearch2 lexeme position |