CONVERT_TZ() is used to convert a datetime to a different time zone.
SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET')
2004-01-01 13:00:00
SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00')
2004-01-01 22:00:00