Query Run
SELECT 0+CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York'); 7 years ago
SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York'); 7 years ago
SELECT @@global.time_zone, @@session.time_zone; # SELECT... 7 years ago
SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','CET'); 7 years ago
SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','Europe/Prague'); 7 years ago
SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); 7 years ago
SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); 7 years ago
SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); 7 years ago