TIMESTAMP

Query>

SELECT SYSDATE

     , TO_TIMESTAMP(SYSDATE)

     , CAST(SYSDATE AS TIMESTAMP)

     , CURRENT_TIMESTAMP

     , CURRENT_TIMESTAMP(0)

     , SYSTIMESTAMP

     , LOCALTIMESTAMP

     , DBTIMEZONE

  FROM DUAL;

Result>

SYSDATE

2011/12/02 13:31:03

TO_TIMESTAMP(SYSDATE)

2011/12/02 00:00:00

CAST(SYSDATEASTIMESTAMP)

2011/12/02 13:31:03

CURRENT_TIMESTAMP

2011/12/02 13:31:03 +09:00

CURRENT_TIMESTAMP(0)

2011/12/02 13:31:04 +09:00

SYSTIMESTAMP

2011/12/02 13:31:03 +09:00

LOCALTIMESTAMP

2011/12/02 13:31:03

DBTIMEZONE

+09:00