Daylight saving time

Started by Dennis Bjorklundabout 21 years ago3 messages
#1Dennis Bjorklund
db@zigo.dhs.org

I found a nice page about daylight saving time that I want to share:

http://timeanddate.com/time/aboutdst.html

Here are some fun quotes from the page:

"Sometimes DST is used for longer periods than just one summer, as in the
United States during World War II. From 3 Feb 1942 to 30 Sep 1945 most of
United States had DST all year, it was called "War Time"."

"many countries change the transition days/principles every year because
of special happenings or conditions that has happened or will happen."

Also notice the current list of DST changes for this fall 2004:

http://timeanddate.com/time/dst2004b.html

I can understand why they did not try to formalize that in the sql spec.

ps. This letter does not mean that I think it's bad to handle time zone
names, just that it's even more difficult then I first thought.

--
/Dennis Bj�rklund

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dennis Bjorklund (#1)
Re: Daylight saving time

Dennis Bjorklund <db@zigo.dhs.org> writes:

ps. This letter does not mean that I think it's bad to handle time zone
names, just that it's even more difficult then I first thought.

This is why we are being careful not to introduce any local changes into
the zic database. We can just drop in upstream changes from time to
time; or users can drop in copies if they need an update and it's the
wrong time of the PG release cycle.

regards, tom lane

#3Noname
acfernando@hotmail.com
In reply to: Dennis Bjorklund (#1)
Re: Daylight saving time

Dear Dennis and my Fellowmen,

How would you like to evaluate a new simplified time zone system for
the world and in decimal? This is found in
http://www.geocities.com/peacecrusader888/timezone.htm.

Best regards,
Aristeo Canlas Fernando, Peace Crusader, ICD
Motto: pro aris et focis
http://www,geocities.com/peacecrusader888/

db@zigo.dhs.org (Dennis Bjorklund) wrote in message news:<Pine.LNX.4.44.0410240939310.2015-100000@zigo.dhs.org>...

Show quoted text

I found a nice page about daylight saving time that I want to share:

http://timeanddate.com/time/aboutdst.html

Here are some fun quotes from the page:

"Sometimes DST is used for longer periods than just one summer, as in the
United States during World War II. From 3 Feb 1942 to 30 Sep 1945 most of
United States had DST all year, it was called "War Time"."

"many countries change the transition days/principles every year because
of special happenings or conditions that has happened or will happen."

Also notice the current list of DST changes for this fall 2004:

http://timeanddate.com/time/dst2004b.html

I can understand why they did not try to formalize that in the sql spec.

ps. This letter does not mean that I think it's bad to handle time zone
names, just that it's even more difficult then I first thought.