convert time zone

CONVERT_TZ (dt, from_tz,to_tz)

SELECT convert_tz(sh_player_report.end_on,'UTC',sh_player_report.tz_name) as end_date , convert_tz(sh_player_report.start_on,'UTC',sh_player_report.tz_name) as start_on from sh_player_report where report_id=17183;