| 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: | Whole Thread | Raw Message | 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 |