CREATE OR REPLACE 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;
/
CREATE OR REPLACE FUNCTION oracle_to_unix(in_date IN DATE)
RETURN NUMBER
IS
BEGIN
RETURN (in_date -TO_DATE('19700101','yyyymmdd'))*86400 -
TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezo
ne),1,3))*3600;
END;
/