Date: Wed, 28 Jul 2010 14:44:59 -0400 From: Jon Radel <jon@radel.com> To: freebsd-questions@freebsd.org, mginsburg@collaborativefusion.com Subject: Re: Timestamp + Interval time zone issues Message-ID: <4C507AAB.8000709@radel.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
This is a cryptographically signed message in MIME format. --------------ms040206030408080901020407 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable 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=20 > hour'::interval; > ?column? ------------------------- > 01/03/2011 14:00:00 EST > > Any idea why the adding of the interval is converting the result into=20 > EST instead of EDT? Because Daylight Saving Time will be over by 1/3/2011? Does it still=20 happen if you use a statically entered time stamp that's during Daylight Saving? --=20 --Jon Radel jon@radel.com --------------ms040206030408080901020407--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4C507AAB.8000709>