Timestamp + Interval time zone issues
    Mike Ginsburg 
    mginsburg at collaborativefusion.com
       
    Wed Jul 28 18:38:42 UTC 2010
    
    
  
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 at collaborativefusion.com
    
    
More information about the freebsd-questions
mailing list