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; /
