oracle 简单的sysTimeStamp类型转date 类型

oracle 简单的SYSTIMESTAMP 类型转date 类型

SELECT SYSTIMESTAMP , SYSTIMESTAMP+0 FROM dual;

SAMPLE_TIME

---------------------------------------------------------------------------

06-MAY-14 05.17.14.651 PM