CONVERT_TZ(datetime, from_tz, to_tz) Example: SELECT CONVERT_TZ('2031-09-21 02:42:14', 'UTC', 'America/New_York'); output: 2031-09-20 22:42:14
##Syntax: ##CONVERT_TZ(datetime, from_tz, to_tz) SELECT CONVERT_TZ('2008-05-15 12:00:00','+00:00','+10:00'); ##Output: 2008-05-15 22:00:00