오라클 UNIX timestamp to date

timestamp to date

SELECT 1552098130 / (60 * 60 * 24) + TO_DATE('19700101090000', 'YYYYMMDDHH24MISS') FROM DUAL;

 

 

 

timestamp to char

SELECT TO_CHAR(1552098130 / (60 * 60 * 24) + TO_DATE('19700101090000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') FROM DUAL;