Re: Mismapping of Mountain Time - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: Mismapping of Mountain Time
Date
Msg-id 4D6FCD93020000250003B3E8@gw.wicourts.gov
Whole thread Raw
In response to Re: Mismapping of Mountain Time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Mismapping of Mountain Time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Josh Berkus <josh@agliodbs.com> writes:

>> There is actually a time zone "Navajo", which is a *separate*
>> time zone from US/Mountain.  Ideas on how this happened?
>
> It's not all that separate: per the Olsen database,
>
> Link    America/Denver        US/Mountain
> Link    America/Denver        Navajo

Yeah, it gets complicated, since the State of Arizona ignores
Daylight Saving Time adjustments.  On the other hand, most of
Arizona is covered by the Navajo Nation, which *does* observe DST.
Except for some government offices on the reservation.  And the Hopi
Nation goes along with the local state rules, so pay attention.  :-/

So, yeah, Navajo is always the same as most of US/Mountain, but the
parts in Arizona don't ignore DST like the rest of the state does.

-Kevin

pgsql-bugs by date:

Previous
From: Jon Nelson
Date:
Subject: Re: Mismapping of Mountain Time
Next
From: Josh Berkus
Date:
Subject: Re: Mismapping of Mountain Time