Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBFG3s009926 for ; Fri, 15 Dec 2000 11:03:54 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eBFG48L11013; Fri, 15 Dec 2000 11:04:08 -0500 (EST) To: Alessio Bragadini cc: SQL for PostgreSQL list Subject: Re: Confused by timezones In-reply-to: <3A3A0D4C.E80E6C12@albourne.com> References: <3A3A0D4C.E80E6C12@albourne.com> Comments: In-reply-to Alessio Bragadini message dated "Fri, 15 Dec 2000 14:23:40 +0200" Date: Fri, 15 Dec 2000 11:04:08 -0500 Message-ID: <11010.976896248@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200012/168 X-Sequence-Number: 502 Alessio Bragadini writes: > village=# set TimeZone TO PST; I'm guessing that's not a legal timezone name on your platform. On my box I have to spell it "PST8PDT" ... note that the displayed abbreviation is not the same as the name used to set the timezone. regards, tom lane