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 _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
