MySQL converting datetime to another timezone - given datetime and timezone name?

[JerryMungo]

.

 

[gkm]

Have you looked at the convert timezone function:
http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_convert-tz

Be sure to read the notes for this function.

 

[JerryMungo]

Have you looked at the convert timezone function:
http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_convert-tz

Be sure to read the notes for this function.

I have, thanks, unfortunately it requires the timezone DB to be installed and my service provider doesn't allow that. Looks like I'll have to do it in php. I hate hacking WP, that's all