转换成秒 create or replace function to_TimeMillis(sdate in date) return number is Result number; begin select (sdate - to_date('19700101 8:00:00','YYYYMMDD hh24:mi:ss'))*1000*60*60*24 into Result from dual; return(Result); end to_TimeMillis;转换成date select to_date('19700101 8:00:00','YYYYMMDD hh24:mi:ss'))+x/1000/60/60/24 from dual; x就是number
create or replace function to_TimeMillis(sdate in date) return number is
Result number;
begin
select (sdate -
to_date('19700101 8:00:00','YYYYMMDD hh24:mi:ss'))*1000*60*60*24
into Result
from dual;
return(Result);
end to_TimeMillis;转换成date
select to_date('19700101 8:00:00','YYYYMMDD hh24:mi:ss'))+x/1000/60/60/24 from dual;
x就是number