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 |