Date: Wed, 28 Jul 2010 15:43:44 -0400 From: Mike Ginsburg <mginsburg@collaborativefusion.com> To: Jon Radel <jon@radel.com> Cc: freebsd-questions@freebsd.org Subject: Re: Timestamp + Interval time zone issues Message-ID: <4C508870.6000208@collaborativefusion.com> In-Reply-To: <4C507AAB.8000709@radel.com> References: <4C5076D7.5040605@collaborativefusion.com> <4C507AAB.8000709@radel.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Jon Radel wrote: > On 7/28/10 2:28 PM, Mike Ginsburg wrote: >> >> 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? > Because Daylight Saving Time will be over by 1/3/2011? Does it still > happen if you use a > statically entered time stamp that's during Daylight Saving? Well now I just feel dumb. Using the same query, but within daylight savings produces the expected result. Thanks for the help. 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?4C508870.6000208>