UTC转GMT+0800(东八区) select from_utc_timestamp(cast(regexp_replace(regexp_replace('2019-07-12T09:01:59.056Z','T',' '),'Z','') as timestamp),"GMT+0800") 【重点在于】： from_utc_timestamp(‘1970-01-01 08:00:00’,