oracle时间戳转换

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;

原文地址:https://www.cnblogs.com/handsomer/p/4283172.html