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 en
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,
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/2
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
