A simpler time zone question

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: A simpler time zone question
Date: 2011-03-28 15:45:26
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D017CC3EC@server.rad-con.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-03-28 15:57:43 Re: A simpler time zone question
Previous Message Rob Richardson 2011-03-28 15:26:03 How do i calculate a finish time when the start time is ambiguous?