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
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