From owner-freebsd-questions@FreeBSD.ORG Wed Jul 28 18:45:10 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 2CDE51065675 for ; Wed, 28 Jul 2010 18:45:10 +0000 (UTC) (envelope-from jon@radel.com) Received: from wave.radel.com (wave.radel.com [216.143.151.4]) by mx1.freebsd.org (Postfix) with ESMTP id ADB408FC1A for ; Wed, 28 Jul 2010 18:45:09 +0000 (UTC) Received: by wave.radel.com (CommuniGate Pro PIPE 4.1.6) with PIPE id 9751776; Wed, 28 Jul 2010 14:45:08 -0400 Received: from [192.168.43.221] (account jon@radel.com HELO braeburn.local) by wave.radel.com (CommuniGate Pro SMTP 4.1.6) with ESMTP-TLS id 9751774; Wed, 28 Jul 2010 14:44:59 -0400 Message-ID: <4C507AAB.8000709@radel.com> Date: Wed, 28 Jul 2010 14:44:59 -0400 From: Jon Radel User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.5; en-US; rv:1.9.1.11) Gecko/20100711 Thunderbird/3.0.6 MIME-Version: 1.0 To: freebsd-questions@freebsd.org, mginsburg@collaborativefusion.com References: <4C5076D7.5040605@collaborativefusion.com> In-Reply-To: <4C5076D7.5040605@collaborativefusion.com> Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha1; boundary="------------ms040206030408080901020407" X-Radel.com-MailScanner-Information: Please contact Jon for more information X-Radel.com-MailScanner: Found to be clean X-Mailer: CommuniGate Pro CLI mailer X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: 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:45:10 -0000 This is a cryptographically signed message in MIME format. --------------ms040206030408080901020407 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable On 7/28/10 2:28 PM, Mike Ginsburg wrote: > > So I have pg 8.4.3 installed, with a database set to EST5EDT time zone.= > > When I run "SELECT NOW()" I get > 07/28/2010 14:27:07.767286 EDT > > showing that the timezone is properly set up. > > 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=20 > hour'::interval; > ?column? ------------------------- > 01/03/2011 14:00:00 EST > > Any idea why the adding of the interval is converting the result into=20 > EST instead of EDT? Because Daylight Saving Time will be over by 1/3/2011? Does it still=20 happen if you use a statically entered time stamp that's during Daylight Saving? --=20 --Jon Radel jon@radel.com --------------ms040206030408080901020407--