Timezones

[indygoof]

Hi all,

has anyone a mysql-table with the worlds countries and timezones in it?
If i would do it manually, this would take me 1-2 weeks for all the inserts so if someone has already coded such a thing,
PLEASE MAIL ME!!!

thanx in advance,

The Goof

[djg_uk]

Hi Goof,

I don't have one personally :-), but I have found a link to a standard table here:

http://www.tip.net.au/~pmyers/General/StandardTimeZones.html

If you import this into your favourite database and export into CSV, you can easily use the following code:

LOAD DATA INFILE 'blah/blah.csv' LINES TERMINATED BY '\n' FIELDS TERMINATED BY ','

to import it into MySQL. There you go.

Regards,

David Grant

[Anon]

ok,
a big THANK YOU for this info!
i searched the internet myself for 2 days, but
the best i found was www.worldtimeserver.com

thx again,
The Goof