▷ Oracle unixtime to date (유닉스시간을 날짜로 변환)

[ Oracle unixtime to date ]

/*
-- 파라미터1개 (UnixTime값)
-- UnixTime값(1252395093)
*/
create or replace function INT2DATE(unix_time in number)
return date
is
RetVal date;
begin
select to_date('19700101090000','YYYYMMDDHH24MISS') + unix_time/86400 into RetVal from dual;

return(RetVal);

end INT2DATE;
/