mysql timezones By sam October 21, 2013 Add the timezone names to the mysql table: root@db1:~# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql> CONVERT_TZ( 'datetime', 'from_timezone', 'to_timezone') Read more