Where can I get a list of most major cities in the world and their GMT
offset and daylight savings time information. It should not be simply
a list of time zones that are linked to a major city. It should
include most big cities in the world. Inclusion of the country name
is also greatly preferred. |
Request for Question Clarification by
rainbow-ga
on
03 Aug 2006 03:50 PDT
Hi zero_mile_club,
Please take a look at the following sites and let me know if they suit
your purposes:
Greenwich Mean Time
http://wwp.greenwichmeantime.com/time-zone/
Taking Lebanon as an example, click on the map of Asia.
http://wwp.greenwichmeantime.com/time-zone/asia/
Then click Lebanon:
http://wwp.greenwichmeantime.com/time-zone/asia/lebanon/
Then Lebanon Time:
http://wwp.greenwichmeantime.com/time-zone/asia/lebanon/time.htm
Here's the information provided:
Eastern European Time (EET)
Standard Time = GMT+2
Summer Time = GMT+3
Clocks on Daylight Saving / Summer Time
from 01:00 GMT 27 March 2005
until 01:00 GMT 30 October 2005
Another example - France:
http://wwp.greenwichmeantime.com/time-zone/europe/european-union/france/
The major cities of France are listed on the left. Clicking on each
will give you the specific time data for that city.
========================
Here are more sites that may fit your needs:
The World Clock - Time Zones
http://www.timeanddate.com/worldclock/
World Time Server
http://www.worldtimeserver.com/current_time_in_GB.aspx
International Time Zones
http://time_zone.tripod.com/
Looking forward to hearing your views.
Best regards,
Rainbow
|
Clarification of Question by
zero_mile_club-ga
on
03 Aug 2006 12:11 PDT
Hi Rainbow-ga.
1.) I am looking for a database. By database, I mean a list in one
format or other but with all of the information in one place easy to
read. Not a website that must be navigated to get the information
from many different pages.
2.) http://wwp.greenwichmeantime.com has good info, but bad format.
http://time_zone.tripod.com/ has good format (all 1 page) but bad data
(No DST. Only countries, not cities.)
|
Request for Question Clarification by
rainbow-ga
on
03 Aug 2006 13:13 PDT
After further research, I haven't been able to locate exactly what you
want. The closest I have come is the following site that fits your
criteria except no cities:
http://www.freesearching.com/zip_codes_intl.htm
Not what you want but I wanted to show you this interesting site:
http://www.timeticker.com/
Best regards,
Rainbow
|
Request for Question Clarification by
pafalafa-ga
on
03 Aug 2006 13:28 PDT
zmc-ga,
Are you looking for a database with entries like:
City-Name, Country Standard Time: UTC+4:30 Daylight Savings Time: (UTC+4:30)
or did you have something more complex in mind?
pafalafa-ga
|
Clarification of Question by
zero_mile_club-ga
on
04 Aug 2006 03:11 PDT
Rainbow, Both links were interesting, thanks for that, but they did
not contain the correct info in a database type of format.
Fafalafa, Yes, that format is close to what I want, except that I need
to know when the DST starts and ends. Data doesn't have to be exactly
in a comma separated list, but it does need to be all in one page
(actually up to 5 pages is fine) that I can copy and edit very easily
to create a database.
|
Request for Question Clarification by
pafalafa-ga
on
04 Aug 2006 05:07 PDT
I'm afraid the dates requirements really complicates things.
The DST dates are quite mercurial, changing year to year and in some
places -- most notably the US -- slated to change quite dramatically
as a new law has redefined DST dates, by extending the period of
daylight savings.
Sorry...but I don't think you're likely to get what you're asking for.
pafalafa-ga
|
Clarification of Question by
zero_mile_club-ga
on
05 Aug 2006 03:10 PDT
Pafalafa, I am willing to accept that the DST dates may change in the
future. I hope that any source found will also update themselves in
the future. Even if not, its better to have something now rather than
nothing ever :-)
|
Request for Question Clarification by
pafalafa-ga
on
05 Aug 2006 07:06 PDT
Lordy, this one's a bear!
I found a program that lists out several hundred cities around the
world in the following format:
==========
(103) Canada - Yukon, Whitehorse (GMT-8.0) ® - Daylight Saving is active
7.47.00 Saturday 5. Aug 2006 -0700 PDT
DST start : 2.00.00 Sunday 2. Apr 2006 -0800 PST
DST end : 2.00.00 Sunday 29. Oct 2006 -0700 PDT
(104) Canary Islands, Las Palmas (GMT+0.0) ® - Daylight Saving is active
15.47.00 Saturday 5. Aug 2006 +0100 WEST
DST start : 1.00.00 Sunday 26. Mar 2006 +0000 WET
DST end : 2.00.00 Sunday 29. Oct 2006 +0100 WEST
(105) Cape Verde, Praia (GMT-1.0)
13.47.00 Saturday 5. Aug 2006 -0100
(106) Cayman Islands (GBR), George Town (GMT-5.0)
9.47.00 Saturday 5. Aug 2006 -0500 EST
(107) Central African Republic, Bangui (GMT+1.0)
15.47.00 Saturday 5. Aug 2006 +0100 CET
(108) Chad, N´Djamena (GMT+1.0)
15.47.00 Saturday 5. Aug 2006 +0100 CET
(109) Chile, Santiago (GMT-4.0) ®
10.47.00 Saturday 5. Aug 2006 -0400 AST
DST start : 0.00.00 Sunday 15. Oct 2006 -0400 AST
DST end : 0.00.00 Sunday 12. Mar 2006 -0300 ADT
(110) China, Beijing (GMT+8.0)
22.47.00 Saturday 5. Aug 2006 +0800 AWST
(111) Christmas Island (AUS), The Settlement (GMT+7.0)
21.47.00 Saturday 5. Aug 2006 +0700
(112) Cocos (Keeling) Islands (AUS) (GMT+6.5)
21.17.00 Saturday 5. Aug 2006 +0630
(113) Colombia, Bogotá (GMT-5.0)
9.47.00 Saturday 5. Aug 2006 -0500 EST
(114) Comoros, Moroni (GMT+3.0)
17.47.00 Saturday 5. Aug 2006 +0300 MSK
(115) Congo Dem. Rep., Kinshasa (GMT+1.0)
15.47.00 Saturday 5. Aug 2006 +0100 CET
(116) Congo Dem. Rep., Lubumbashi (GMT+2.0)
16.47.00 Saturday 5. Aug 2006 +0200 EET
(117) Congo Rep., Brazzaville (GMT+1.0)
15.47.00 Saturday 5. Aug 2006 +0100 CET
(118) Cook Islands, Avarua (GMT-10.0)
4.47.00 Saturday 5. Aug 2006 -1000 HST
(119) Costa Rica, San José (GMT-6.0)
8.47.00 Saturday 5. Aug 2006 -0600 CST
(120) Croatia, Zagreb (GMT+1.0) ® - Daylight Saving is active
16.47.00 Saturday 5. Aug 2006 +0200 CEST
DST start : 2.00.00 Sunday 26. Mar 2006 +0100 CET
DST end : 3.00.00 Sunday 29. Oct 2006 +0200 CEST
(121) Cuba, Havana (GMT-5.0) ® - Daylight Saving is active
10.47.00 Saturday 5. Aug 2006 -0400 EDT
DST start : 0.00.00 Sunday 1. Jan 2006 -0500 EST
DST end : 3.00.00 Sunday 29. Oct 2006 -0400 EDT
==========
Will that do the trick for what you need?
pafalafa-ga
|
Clarification of Question by
zero_mile_club-ga
on
07 Aug 2006 03:46 PDT
Pafalafa-ga, Yep, it is tough. That is why I posted on google
answers :-) From the data shown, it doesn't seem to actually cover
"most major cities", as there are many more major cities in China than
just Beijing. However, I may accept this partial answer and release
the full payment depending on this question: How much the program
costs and if it is easy to extract the data of which you gave a
sample?
|
Request for Question Clarification by
pafalafa-ga
on
07 Aug 2006 18:34 PDT
It's freeware!
It has just about all major cities in the world...China is some sort
of special case, since Bejing seems to be the only city with an
"official" time, even though the country spans numerous time zones.
Go figure!
Anyway, give it a try. The program is the World Time Explorer:
http://www.worldtimeexplorer.com/index.html
It downloaded cleanly for me, and passed all my spyware screens. It
was pretty easy to generate the cities list, though I don't have the
program in front of me at the moment, so I can't walk you through the
steps (it did take a bit of hunting around). If you have a problem
finding it, just let me know.
By the way, the author of the program strikes me as just the type of
person to offer up his assistance to anyone wanting to create, say, a
formatted list of cities. You might want to drop him an email.
Let me know how things go, and what else you need to make for a complete answer.
Cheers,
pafalafa-ga
|
Clarification of Question by
zero_mile_club-ga
on
08 Aug 2006 04:59 PDT
Pafalafa, It seem that this discussion has all been classifed as
"clarification", so how do I mark this question as complete so that
you get credit?
|
