A bozo's blog
SELECT TO_CHAR(TO_DATE(
'19700101'
,
'YYYYMMDD'
) + (1364986608/(60*60*24)),
'DD:MM:YYYY HH24:MI:SS'
) my_date FROM dual;