select to_date('1970101','yyyymmdd')+(1494328141/86400)+to_number(substr(tz_offset(sessiontimezone),1,3))/24 ztime from dual;