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

Re: Postgres timestamps are out by one hour

From: "Simon Kinsella" <simon(at)bluefiresystems(dot)co(dot)uk>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres timestamps are out by one hour
Date: 2006-10-26 16:07:01
Message-ID: 20061026160705.D621716A928@smtp01l.fasthosts.co.uk (view raw or flat)
Thread:
Lists: pgsql-admin
template1=# show timezone;
 TimeZone
----------
 GMT0

Thanks.

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Thursday, October 26, 2006 4:53 PM
To: Simon Kinsella
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgres timestamps are out by one hour 

"Simon Kinsella" <simon(at)bluefiresystems(dot)co(dot)uk> writes:
> The shell / system timestamp is correct local time (London, daylight 
> saving), but the postgres time is one hour behind.

What does SHOW TIMEZONE say?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org



In response to

Responses

pgsql-admin by date

Next:From: Fernando MachadoDate: 2006-10-26 16:08:03
Subject:
Previous:From: Ben SuffolkDate: 2006-10-26 15:57:51
Subject: Re: TCP/IP connection problem

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