Country Name | State/Providence | City | -/+GMT | for each row.
format txt, xls, cvs, all fine.
need source where data was taken.
Need all countries
if additional useful variables included it's fine, such as country
code. if city is too much work, can be left out. many thanks. |
Request for Question Clarification by
rainbow-ga
on
16 Mar 2006 14:49 PST
I can provide you with an excel sheet with the following:
Country
Country code
International dialing code
Start GMT
End GMT
Would this interest you?
Rainbow~
|
Clarification of Question by
forexman-ga
on
17 Mar 2006 10:06 PST
it is essential that i can see the following relation on each row:
Country name | State | GMT value to each state.
the reason is that depending what state the user selects, a time
adjustment to that state needs to be made by the program.
for a solution with Starting GMT and Ending GMT, i still need to find
which states/prodidences have different values. countries like US and
China, Canada can become a problem, since they are horizontal in
shape.
thank you very much for getting back to me.
|
Request for Question Clarification by
rainbow-ga
on
17 Mar 2006 10:16 PST
Thank you for your clarification.
Am I correct in understanding, you will need the time zones for each
of the US states and each providence in Canada, in addition to the
rest of the countries of the world?
Are there any other countries you will need split up like this?
Rainbow~
|
Request for Question Clarification by
rainbow-ga
on
17 Mar 2006 11:39 PST
After additional research, I have found the time it would take to
compile the required information is not worthwhile for the price
offered.
For instance, one obstacle I have come across is the difference in the
data between the winter and summer months because of Daylight Savings
Time.
Hopefully another researcher will be able to assist you.
Best regards,
Rainbow
|
Clarification of Question by
forexman-ga
on
17 Mar 2006 13:48 PST
ok so how about Americas, Canada, Europe, Australia only.
the GMT value must be associated to State level and for Europe on a
city Level since they dont have states (Europe is easy job)
also you can ignore the issue of daylight savings. GMT value is a
fixed value, just like you have it in your windows time zone settings
drop down.
please let me know if this makes it easier for you and let me know
about any price adjustment.
|
Request for Question Clarification by
rainbow-ga
on
17 Mar 2006 14:00 PST
Please let me know if I understand correctly. You require the following:
USA state -/+GMT
Canada province -/+GMT
Europe country -/+GMT
Australia state/territory -/+GMT
Rainbow~
|
Request for Question Clarification by
rainbow-ga
on
17 Mar 2006 15:42 PST
I have compiled the following in txt format.
USA state -/+GMT
Canada province -/+GMT
Europe country -/+GMT
Australia state -/+GMT
Please let me know if this sufficently answers your question and I
will upload the file for you to download.
Best regards,
Rainbow
|
Clarification of Question by
forexman-ga
on
17 Mar 2006 23:12 PST
if Europe contains the GMT value for each city or 'largest unit'
(since they dont have states), this is definitely sufficient! thank
you very much.
USA | NEW YORK | -5 GMT
USA | CALIFORNIA | -8 GMT
USA | FLORIDA | -5 GMT
....
SWITZERLAND | ZURICH | +1 GMT
SWITZERLAND | BASEL | +1 GMT
...
thanks!
|
Request for Question Clarification by
rainbow-ga
on
17 Mar 2006 23:21 PST
The only cities I have found this data for are all in the CET (GMT+1)
time zone. These are the cities:
Amsterdam, Holland
Barcelona, Spain
Berlin, Germany
Brussels, Belgium
Copenhagen, Denmark
Dusseldorf, Germany
Florence, Italy
Frankfurt, Germany
The Hague, Holland
Hamburg, Germany
Madrid, Spain
Marseilles, France
Milan, Italy
Munich, Germany
Naples, Italy
Nice, France
Paris, France
Prague, Czech Republic
Rome, Italy
Stockholm, Sweden
Venice, Italy
Zurich, Switzerland
However, any city in a European country would have the same time zone
as any other sity in that country, since no European country has two
different time zones.
Let me know how to proceed.
Rainbow~
|
Clarification of Question by
forexman-ga
on
18 Mar 2006 11:30 PST
that is fine. will add the other cities myself and use the same value
for the capital city. thanks. let me know how i can pay.
appreciate your work. will definitely use this service more often.
|
