获取从1970-01-01: 00:00:00 到当前时间的秒数(返回一个十位格式的数字)
create or replace function F_SysTime1970 return number is
Result number;
v_base_time0 date;
v_base_time date;
v_starttime number(10);
Begin
v_base_time0 := to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS');
v_base_time := to_date(to_char(SYS_EXTRACT_UTC(FROM_TZ(Timestamp '1970-01-1 00:00:00',SESSIONTIMEZONE)),'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS');
v_starttime := (Sysdate - v_base_time0) * 86400 + (v_base_time - v_base_time0) * 86400;
Result := v_starttime;
return(Result);
end F_SysTime1970;