Skip site navigation (1) Skip section navigation (2)

Re: LOCALTIMESTAMP has wrong time zone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: JB(at)BlackSkyTech(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: LOCALTIMESTAMP has wrong time zone
Date: 2011-02-24 22:35:18
Message-ID: 29565.1298586918@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"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

In response to

Responses

pgsql-bugs by date

Next:From: Jonathan BrinkmanDate: 2011-02-24 22:38:55
Subject: Re: LOCALTIMESTAMP has wrong time zone
Previous:From: Kevin GrittnerDate: 2011-02-24 22:06:09
Subject: Re: LOCALTIMESTAMP has wrong time zone

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group