Date: Wed, 28 Jul 2010 11:44:13 -0700 From: Chuck Swiger <cswiger@mac.com> To: Mike Ginsburg <mginsburg@collaborativefusion.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Timestamp + Interval time zone issues Message-ID: <3CE0D0C0-2035-44F9-A677-0A69B2A071D6@mac.com> In-Reply-To: <4C5076D7.5040605@collaborativefusion.com> References: <4C5076D7.5040605@collaborativefusion.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi-- On Jul 28, 2010, at 11:28 AM, Mike Ginsburg wrote: > 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? I'd image this is because Jan 3 is in EST: % date -j '01031600' Sun Jan 3 16:00:00 EST 2010 Regards, -- -Chuck
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3CE0D0C0-2035-44F9-A677-0A69B2A071D6>