create or replace noneditionable 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;
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
http://www.cndba.cn/hbhe0316/article/116471
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle
CNDBA社区
