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

Поиск
Список
Период
Сортировка
От Richard Troy
Тема Production systems beware: U.S. Daylight Savings Time comes at a new time this year
Дата
Msg-id Pine.LNX.4.33.0702011306270.23745-100000@denzel.in
обсуждение исходный текст
Ответ на Re: Any Plans for cross database queries on the same server?  (Mark Walker <furface@omnicode.com>)
Ответы Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  (Ron Johnson <ron.l.johnson@cox.net>)
Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
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.

Regards,
Richard

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/


В списке pgsql-general по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: I "might" have found a bug on 8.2.1 win32
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year