字符串转数字、数字转时间戳、时间戳转日期字符串：
select t.id,t.license_no,t.pass_port_name1,t.data_source1,to_char(to_timestamp(to_number(t.pass_tim1)/1000),'yyyy-MM-dd HH24:mi:ss') as pass_tim1 from motorvehicle_copy_plate_v2 t
where 1=1
order by t.pass_tim1 desc
limit 100
View Code
说明：pass_tim1字段类型是字符串类型
