更新时间:2021-07-25 05:31:58
格式是 yyyy-MM-dd'T'HH:mm:ss.SSSXXX"
.请注意在'T'周围的单引号
The format is yyyy-MM-dd'T'HH:mm:ss.SSSXXX"
.Note the single quotes surrounding 'T'
select from_unixtime(unix_timestamp("2017-09-27T19:25:15.927-07:00", "yyyy-MM-dd'T'HH:mm:ss.SSSXXX"))