From: | Joseph S <jks(at)selectacast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Timezones in 8.2.7 |
Date: | 2008-03-25 20:46:25 |
Message-ID: | fsboc0$2ct8$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Was there something wrong with the tzdata distributed in 8.2.7?
current_timestamp is still using EST, but the date command run from the
command line is correctly returning EDT
[local]:owl=# select version(), current_timestamp;
version
| now
---------------------------------------------------------------------------------------------------+-------------------------------
PostgreSQL 8.2.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
20060404 (Red Hat 3.4.6-3) | 2008-03-25 14:33:11.955247-05
(1 row)
Time: 0.584 ms
[local]:owl=# select now();
now
-------------------------------
2008-03-25 14:33:24.291317-05
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Swaminathan Saikumar | 2008-03-25 21:34:56 | NauckIT PostgreSQL provider working with Mono? |
Previous Message | Thomas Kellerer | 2008-03-25 20:33:38 | Re: PostgreSQL, clusters and load-balance |