I see that the query “select '2011-11-6 00:59'::timestamptz’” returns a timestamptz with a time zone of -4, which is correct, since I’m in the Eastern time zone and the change from EDT to EST will happen at 2011-11-6 02:00. The query “select '2011-11-6 01:01'::timestamptz” gives me a time zone offset of -5, which tells me that PostgreSQL assumes that the time change has already happened. Can I count on that behavior? Will PostgreSQL always assume that an ambiguous time is in standard instead of daylight time?
Thanks again!
RobR