Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Richard Troy <rtroy(at)ScienceTools(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>, pgsql-announce(at)postgresql(dot)org
Subject: Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year
Date: 2007-02-01 21:08:14
Message-ID: 1170364093.5451.40.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2007-02-01 at 15:15, Richard Troy wrote:
> Hello All,
>
> it was recently brought to my attention that last year the U.S. altered
> the dates when Daylight Savings Time starts and ends. Many if not most
> computers presume the old change dates and therefore, if left to change
> automatically, will change at the wrong times. This will be vital for
> people in the database community who manage applications that need
> accurate timestamps.
>
> You can read up on this issue here, among other places:
>
> http://www.washingtonpost.com/wp-dyn/content/article/2007/01/31/AR2007013102318.html?referrer=emailarticle
>
> I've never investigated how NTP servers handle DST changes - that is,
> whether they switch with the fabrication that we have more daylight hours
> or leave it to clients. Hmmm... Anybody know? It'd be nice to know that
> we can trust our NTP servers to tell our systems what time it is and
> therefore ignore this issue for those systems that are NTP clients.

As far as I know, NTP servers run on UTC, so time zone changes are
outside the realm of things they worry about.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-01 21:12:06 Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year
Previous Message korryd 2007-02-01 21:06:47 Re: How to allow users to log on only from my application