即 EPOCH 时间:自 Epoch(1970-01-01) 以来的秒数.使用这个:

That is EPOCH time: number of seconds since Epoch(1970-01-01). Use this:

SELECT CAST(DATE '1970-01-01' + ( 1 / 24 / 60 / 60 ) * '1310112003' AS TIMESTAMP) FROM DUAL;

结果:

08-JUL-11 08.00.03.000000000 AM