From owner-freebsd-questions@FreeBSD.ORG Wed Jul 28 18:44:48 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9EF95106566C for ; Wed, 28 Jul 2010 18:44:48 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from asmtpout027.mac.com (asmtpout027.mac.com [17.148.16.102]) by mx1.freebsd.org (Postfix) with ESMTP id 8736E8FC18 for ; Wed, 28 Jul 2010 18:44:48 +0000 (UTC) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=us-ascii Received: from cswiger1.apple.com ([17.209.4.71]) by asmtp027.mac.com (Sun Java(tm) System Messaging Server 6.3-8.01 (built Dec 16 2008; 32bit)) with ESMTPSA id <0L6A00LSK6PP5A10@asmtp027.mac.com> for freebsd-questions@freebsd.org; Wed, 28 Jul 2010 11:44:14 -0700 (PDT) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=6.0.2-1004200000 definitions=main-1007280126 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.0.10011,1.0.148,0.0.0000 definitions=2010-07-28_08:2010-07-28, 2010-07-28, 1970-01-01 signatures=0 From: Chuck Swiger In-reply-to: <4C5076D7.5040605@collaborativefusion.com> Date: Wed, 28 Jul 2010 11:44:13 -0700 Message-id: <3CE0D0C0-2035-44F9-A677-0A69B2A071D6@mac.com> References: <4C5076D7.5040605@collaborativefusion.com> To: Mike Ginsburg X-Mailer: Apple Mail (2.1081) Cc: FreeBSD Questions Subject: Re: Timestamp + Interval time zone issues X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Jul 2010 18:44:48 -0000 Hi-- On Jul 28, 2010, at 11:28 AM, Mike Ginsburg wrote: > When I then try to add an interval to a statically entered time stamp, it gets all strange: > SELECT '01/03/2011 16:00:00-04'::timestamp with time zone + '-1 hour'::interval; > ?column? ------------------------- > 01/03/2011 14:00:00 EST > > Any idea why the adding of the interval is converting the result into EST instead of EDT? I'd image this is because Jan 3 is in EST: % date -j '01031600' Sun Jan 3 16:00:00 EST 2010 Regards, -- -Chuck