Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 28 Jul 2010 14:28:39 -0400
From:      Mike Ginsburg <mginsburg@collaborativefusion.com>
To:        FreeBSD Questions <freebsd-questions@freebsd.org>
Subject:   Timestamp + Interval time zone issues
Message-ID:  <4C5076D7.5040605@collaborativefusion.com>

next in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4C5076D7.5040605>