MYSQL Timezone support
In order to timezone support to be around, the hosting company should have executed this:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql ...


The mysql_tzinfo_to_sql utility should load the time zones. Please make sure the host company has done this. If they can't or won't,


you could into Amazon EC2, you could have full access to MySQL and can run it yourself
Find a willing hosting company


BTW Here is the MySQL Documentation for CONVERT_TZ : http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_convert-tz