SQL
CREATE OR REPLACE FUNCTION DATA2UNIX (DATA IN DATE)
RETURN INT
AS
RESULTAT INT;
BEGIN
SELECT (CAST(DATA as DATE)-TO_DATE('1970-01-01','YYYY-MM-DD'))*24*60*60 into RESULTAT FROM Dual;
RETURN RESULTAT;
END;SQL
CREATE OR REPLACE FUNCTION UNIX2DATA (DATA IN INT)
RETURN DATE
AS
RESULTAT DATE;
BEGIN
--SELECT TO_TIMESTAMP(TO_DATE('1970-01-01','YYYY-MM-DD') + DATA / 86400) INTO RESULTAT FROM Dual;
SELECT TO_DATE('1970-01-01','YYYY-MM-DD') + NUMTODSINTERVAL(DATA, 'SECOND') INTO RESULTAT FROM Dual;
RETURN RESULTAT;
END;