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