CONVERT_TZ() is used to convert a datetime to a different time zone.

Example

SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET')

Returns

2004-01-01 13:00:00

 

Example

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

Returns

2004-01-01 22:00:00