postgres@Cloud-DB1:~$ psql beta_cms_main -c "show timezone;" TimeZone ---------- EST (1 row)
postgres@Cloud-DB1:~$ psql beta_cms_main -c "select now();" now ------------------------------- 2011-02-24 17:42:40.023498-05 (1 row) postgres@Cloud-DB1:~$ psql beta_cms_main -c "select localtimestamp;" timestamp ---------------------------- 2011-02-24 17:42:40.078052 (1 row) All looks correct to me! (it is 5:42PM EST now). -----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thursday, February 24, 2011 5:35 PM To: Kevin Grittner Cc: j...@blackskytech.com; pgsql-bugs@postgresql.org Subject: Re: [BUGS] LOCALTIMESTAMP has wrong time zone "Kevin Grittner" <kevin.gritt...@wicourts.gov> writes: > "Jonathan Brinkman" <j...@blackskytech.com> wrote: >> My default timestamps in my database all are +5 hours in the future > Can you copy paste actual statements and results? In particular, let's see the result of these commands in psql: show timezone; select now(); select localtimestamp; What it sounds like to me is an incorrect default setting of "timezone" but it's hard to be sure with no concrete data. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs