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