Oracle Function[@more@]

SQL> select to_timestamp('16-APR-09 05.37.34') from dual;

TO_TIMESTAMP('16-APR-0905.37.34')
---------------------------------------------------------------------------
16-APR-09 05.37.34.000000000 AM

SQL>

SQL> select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER
------------------------
468561

SQL> select sysdate from dual;

SYSDATE
-------------------
2009-04-16 05:37:22

SQL> select systimestamp from dual;

SYSTIMESTAMP
---------------------------------------------------------------------------
16-APR-09 05.37.34.018235 AM +08:00

ITPub博客

Oracle timestamp_to_scn and scn_to_timestamp