SELECT unix_timestamp(substr(time,1,19),‘yyyy-MM-dd HH:mm:ss’)*1000+substr(time,21,3),write_time from tableA
原始时间格式:2020-09-15 10:35:33:841
转换后时间戳:1600137333841
SELECT unix_timestamp(substr(time,1,19),‘yyyy-MM-dd HH:mm:ss’)*1000+substr(time,21,3),write_time from tableA
原始时间格式:2020-09-15 10:35:33:841
转换后时间戳:1600137333841