From: | "Jonathan Brinkman" <JB(at)BlackSkyTech(dot)com> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Kevin Grittner'" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: LOCALTIMESTAMP has wrong time zone |
Date: | 2011-02-24 22:43:38 |
Message-ID: | 000b01cbd474$47e70b50$d7b521f0$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
postgres(at)Cloud-DB1:~$ psql beta_cms_main -c "show timezone;"
TimeZone
----------
EST
(1 row)
postgres(at)Cloud-DB1:~$ psql beta_cms_main -c "select now();"
now
-------------------------------
2011-02-24 17:42:40.023498-05
(1 row)
postgres(at)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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, February 24, 2011 5:35 PM
To: Kevin Grittner
Cc: JB(at)BlackSkyTech(dot)com; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] LOCALTIMESTAMP has wrong time zone
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> "Jonathan Brinkman" <JB(at)BlackSkyTech(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2011-02-24 22:58:47 | Re: LOCALTIMESTAMP has wrong time zone |
Previous Message | Jonathan Brinkman | 2011-02-24 22:38:55 | Re: LOCALTIMESTAMP has wrong time zone |