很简单,具体function如下
function unix_to_oracle(in_number NUMBER) return date is
begin
return(TO_DATE('19700101', 'yyyymmdd') + in_number / 86400 +
TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) / 24);
end unix_to_oracle;
完.
很简单,具体function如下
function unix_to_oracle(in_number NUMBER) return date is
begin
return(TO_DATE('19700101', 'yyyymmdd') + in_number / 86400 +
TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) / 24);
end unix_to_oracle;
完.
转载于:https://my.oschina.net/u/2012158/blog/535300