http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html#c11545
Note that if you are trying to keep your own database of cities and their timezones, you can NOT use the mysql.time_zone_name.Time_zone_id as your FK because the key will change the next time you get a new "tzdata" update (like from an "apt-get update") and re-run "mysql_tzinfo_to_sql tz_file". You'll have to store the "Name" column instead otherwise you loose data integrity. That script wipes the tables and re-creates them! rather than doing an UPDATE to existing records as you would reasonably expect. *sigh* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org