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>