Bluehost How-To : MySQL CONVERT_TZ() not supported?

Bluehost is among our best web hosts. Sign up with bluehost here

This is a bluehost question posted by jcontent on 08 August 2008

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.

You can read more about bluehost in detail or sign up now with bluehost web hosting