How to convert time zone in MySQL?

MySQL Server allows to convert time zone using the CONVERT_TZ() function, which performs time zone conversions of datetime values:

SELECT CONVERT_TZ('2005-01-27 13:30:00', '+01:00', '+03:00');
+-------------------------------------------------------+ 
| CONVERT_TZ('2005-01-27 13:30:00', '+01:00', '+03:00') | 
+-------------------------------------------------------+ 
| 2005-01-27 15:30:00 | 
+-------------------------------------------------------+

CONVERT_TZ() assumes that the given datetime value has the time zone represented by the first hour/minute offset argument, and converts it to a value in the time zone represented by the second offset argument. The result is that you get the same datetime value, from the point of view of a different time zone.