Thread: Daylight saving time

Daylight saving time

From
Dennis Bjorklund
Date:
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



Re: Daylight saving time

From
Tom Lane
Date:
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


Re: Daylight saving time

From
acfernando@hotmail.com (Peace Crusader)
Date:
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>...
> 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.