How to convert time zone in MySQL

CONVERT_TZ(date,from_tz,to_tz): Convert time zone

SELECT CONVERT_TZ(‘2004-01-01 12:00:00','+00:00','+10:00')

-> 2004-01-01 22:00:00

The above is the detailed content of How to convert time zone in MySQL. For more information, please follow other related articles on the PHP Chinese website!