template1=# show timezone;
TimeZone
----------
GMT0
Thanks.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Thursday, October 26, 2006 4:53 PM
To: Simon Kinsella
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres timestamps are out by one hour
"Simon Kinsella" <simon@bluefiresystems.co.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