oracle获取时间毫秒数

select (sysdate-to_date('1970-01-01','yyyy-mm-dd')-8/24)*24*60*60*1000-1* 60 * 60 * 1000  millisecond from dual;

原文地址:https://www.cnblogs.com/guijl/p/3148275.html