Re: LOCALTIMESTAMP has wrong time zone - Mailing list pgsql-bugs

From Tom Lane
Subject Re: LOCALTIMESTAMP has wrong time zone
Date
Msg-id 29565.1298586918@sss.pgh.pa.us
Whole thread Raw
In response to Re: LOCALTIMESTAMP has wrong time zone  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: LOCALTIMESTAMP has wrong time zone  ("Jonathan Brinkman" <JB@BlackSkyTech.com>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: LOCALTIMESTAMP has wrong time zone
Next
From: "Kevin Grittner"
Date:
Subject: Re: LOCALTIMESTAMP has wrong time zone