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
Rob Richardson rob.richard...@rad-con.com writes:
Will PostgreSQL always assume that an ambiguous time is in
standard instead of daylight time?
Yes, I believe that's even documented somewhere. I think it will also
do that if the time is impossible (eg, 02:30 during a forward DST jump)
On 03/28/2011 08:57 AM, Tom Lane wrote:
Rob Richardsonrob.richard...@rad-con.com writes:
Will PostgreSQL always assume that an ambiguous time is in
standard instead of daylight time?
Yes, I believe that's even documented somewhere. I think it will also
do that if the time is impossible (eg,
Steve Crawford scrawf...@pinpointresearch.com writes:
On 03/28/2011 08:57 AM, Tom Lane wrote:
Yes, I believe that's even documented somewhere. I think it will also
do that if the time is impossible (eg, 02:30 during a forward DST jump)
I'd love a link to the documentation specifying that