Timestamp + Interval time zone issues
Mike Ginsburg
mginsburg at collaborativefusion.com
Wed Jul 28 18:38:42 UTC 2010
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 at collaborativefusion.com
More information about the freebsd-questions
mailing list