A simpler time zone question - Mailing list pgsql-general

From Rob Richardson
Subject A simpler time zone question
Date
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D017CC3EC@server.rad-con.local
Whole thread Raw
Responses Re: A simpler time zone question  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: "Rob Richardson"
Date:
Subject: How do i calculate a finish time when the start time is ambiguous?
Next
From: Tom Lane
Date:
Subject: Re: A simpler time zone question