SELECT (TO_DATE('19700101','yyyymmdd') + time_no/86400 +TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone),1,3))/24) FROM dual 时间戳转日期
SELECT ((SYSDATE - TO_DATE('19700101','yyyymmdd'))*86400 - TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone),1,3))*3600) FROM dual 日期转时间戳
SELECT ((SYSDATE - TO_DATE('19700101','yyyymmdd'))*86400 - TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone),1,3))*3600) FROM dual 日期转时间戳