MySQL CONVERT_TZ() not supported?

[jcontent]

HI, I was trying to do a simple datetime timezzone conversion using mysql 5+ function CONVERT_TZ()

mysl ref docs says it relies on timezone tables installed at a database

does anyone have any simple solutions so that I can use this function. Please understand I am not asking to change the timezone settings of mysql or the server, only interested in getting the CONVERT_TZ function to work. It's a simple string concersion that uses a table.

thanks

PS: the tables in question are here http://dev.mysql.com/downloads/timezones.html

[Roy]

I am in the same boat. I use a TIMESTAMP field in mySql to keep up with modification dates, but would like to present them on web pages as US/Central, not US/Mountain. The help desk was clueless on this one. If I can't manage a global conversion at the database level, about all I can do is modify the dates as they are extracted from the tables with ADDDATE(<date from table>,INTERVAL 1 day); Seems like picking your teeth with a tire iron, but it's all I have. If someone comes up with a better idea, I'm all ears.

[alligosh]

Ok, that's definitely reasonable.

The timezone data has now been imported into the mysql.time_zone* tables on all customer boxes.

-Steve