From owner-freebsd-questions@FreeBSD.ORG  Wed Jul 28 18:38:42 2010
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 6F4C2106564A
	for <freebsd-questions@freebsd.org>;
	Wed, 28 Jul 2010 18:38:42 +0000 (UTC)
	(envelope-from mginsburg@collaborativefusion.com)
Received: from mx00.pub.collaborativefusion.com
	(mx00.pub.collaborativefusion.com [206.210.89.199])
	by mx1.freebsd.org (Postfix) with ESMTP id 252A58FC19
	for <freebsd-questions@freebsd.org>;
	Wed, 28 Jul 2010 18:38:41 +0000 (UTC)
Received: from [192.168.2.98]
	(treadshot.ws.pitbpa0.priv.collaborativefusion.com [192.168.2.98])
	(AUTH: LOGIN mginsburg, SSL: TLSv1/SSLv3,256bits,AES256-SHA)
	by wingspan with esmtp; Wed, 28 Jul 2010 14:28:40 -0400
	id 0003F403.000000004C5076D8.000027FF
Message-ID: <4C5076D7.5040605@collaborativefusion.com>
Date: Wed, 28 Jul 2010 14:28:39 -0400
From: Mike Ginsburg <mginsburg@collaborativefusion.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090404)
MIME-Version: 1.0
To: FreeBSD Questions <freebsd-questions@freebsd.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Timestamp + Interval time zone issues
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 28 Jul 2010 18:38:42 -0000

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 
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?

Mike Ginsburg
Collaborative Fusion, Inc.
mginsburg@collaborativefusion.com