Country to Timezone table

[szlamany]

Does anyone know where I could get a country-to-timezone conversion table?

Seems like I can find lots of web sites that do this conversion for you - but I'm looking to get actual tables to store in my DB regarding countries and the timezones they are in.

Thanks!

[Nightwalker83]

I don't know of any site that have them already! However, the computer operating system holds the information already. There might be a way to copy that information that is already stored in the system?

Edit:

Is this of any help?

http://wwp.greenwichmeantime.com/info/timezone.htm

[chris128]

Like Nightwalker said, Windows already has such a list. If you couldn't find any programmatic way of getting this data from Windows then you could resort to just double clicking on the time in the taskbar and then clicking the Time Zone tab and going through each zone in there and noting down which countries are listed next to it.

[dbasnett]

what is available in windows is small. here is a list i compiled TimeZones.txt

it is tab delimited and has abbreviations, names, gmt offsets, and military TZ. i wouldn't swear to it being 100% accurate because...

i discovered there isn't much of a standard for the names. hope it helps.

[szlamany]

Thank you - thank you - thank you!

I'm going to give this to my client and have them clean it up to match a country list they have and add to it if they need to.

If anything gets better with the list I'll post back another copy.

[dbasnett]

that would be great.

[Nightwalker83]

i wouldn't swear to it being 100% accurate because...

Szlamany, could use the website I posted to doubled check your info!

[dbasnett]

Szlamany, could use the website I posted to doubled check your info!

that was one of the sites i used to collect the information.