PostgreSQL

字符串转数字、数字转时间戳、时间戳转日期字符串：

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

说明：pass_tim1字段类型是字符串类型