Re: Mismapping of Mountain Time

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Mismapping of Mountain Time
Date: 2011-03-03 23:19:15
Message-ID: 4D6FCD93020000250003B3E8@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2011-03-03 23:19:43 Re: Mismapping of Mountain Time
Previous Message Jon Nelson 2011-03-03 23:13:55 Re: Mismapping of Mountain Time