FUNCTION: SYS.UNIX_TS_TO_DATE

Source

1 FUNCTION UNIX_TS_TO_DATE(julian_time IN NUMBER)
2    RETURN DATE
3 IS
4   calendar_date DATE;
5 BEGIN
6   calendar_date := date '1970-01-01' + julian_time/60/60/24;
7   RETURN calendar_date;
8 END;