aqquadro

CREATE OR REPLACE FUNCTION F_GET_UNIXTIME (ts IN TIMESTAMP) RETURN NUMBER IS unixTime NUMBER; diffFromEpoch interval day(9) to second(6); sessionTZ VARCHAR(6); BEGIN –get the current timezone SELECT SESSIONTIMEZONE INTO sessionTZ FROM dual; diffFromEpoch := ts – TO_TIMESTAMP_TZ(’1970-01-01 00:00:00 ‘ || sessionTZ, ‘YYYY-MM-DD HH24:MI:SS TZH:TZM’); unixTime := FLOOR( ABS( EXTRACT( SECOND FROM diffFromEpoch ) + EXTRACT( MINUTE [...]