TRUNC(("dt" - date '1970-01-01') * 86400) 86400 TO_CHAR(TO_TIMESTAMP('19700101000000','YYYYMMDDHH24MISS')+NUMTODSINTERVAL("sec",'SECOND'),'YYYY-MM-DD HH24:MI:SS') 1970-01-02 00:00:00