Re: LOCALTIMESTAMP has wrong time zone

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:tgl@sss.pgh.pa.us]
Sent: Thursday, February 24, 2011 5:35 PM
To: Kevin Grittner
Cc: JB@BlackSkyTech.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] LOCALTIMESTAMP has wrong time zone

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> "Jonathan Brinkman" <JB@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