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