Best practices: Handling Daylight-saving time

Поиск
Список
Период
Сортировка
От Együd Csaba
Тема Best practices: Handling Daylight-saving time
Дата
Msg-id 0ID6006FVYQFZX@mail.vnet.hu
обсуждение исходный текст
Ответы Re: Best practices: Handling Daylight-saving time  (Bruno Wolff III <bruno@wolff.to>)
Re: Best practices: Handling Daylight-saving time  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Best practices: Handling Daylight-saving time  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Best practices: Handling Daylight-saving time  (Randall Nortman <postgreslists@wonderclown.com>)
Re: Best practices: Handling Daylight-saving time  (Christopher Browne <cbbrowne@acm.org>)
Список pgsql-general
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24 system.
Where should it be handled: on the server side or on the client side? And
how could I (at all could I???) make it transparent?

Or we must bow to the fact that twice a year there are two unusable hours?
If it cannot be solved technically, than it is acceptable, but if there is a
chance to do it, I'd like to try it.

Our system stores 200-1000 measured data per minute, comming from
substations. The substations clock is synchronized periodically as well.
When the DST is switched there is 1 hour of data missing (or overlapped).
Certainly the client machines are autmatically adjusted for the DST.

How do this others?

Many many thanks,

-- Csaba

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 2005.03.07.




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 2005.03.07.


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problem with inherited table, can you help?...
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: row numbering