oracle时间戳转换时间:2023-03-09 00:05:53 select (to_date('2013-04-09 14:02:15','yyyy-mm-dd hh24:mi:ss') - to_date('1970-01-01','yyyy-mm-dd'))*86400000 from dual;