Oracle Function[@more@]
SQL> select dbms_flashback.get_system_change_number from dual;
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
---------------------------------------------------------------------------
16-APR-09 05.37.34.000000000 AM
SQL>
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
468561
------------------------
468561
SQL> select sysdate from dual;
SYSDATE
-------------------
2009-04-16 05:37:22
-------------------
2009-04-16 05:37:22
SQL> select systimestamp from dual;
SYSTIMESTAMP
---------------------------------------------------------------------------
16-APR-09 05.37.34.018235 AM +08:00
---------------------------------------------------------------------------
16-APR-09 05.37.34.018235 AM +08:00
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66634/viewspace-1020665/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/66634/viewspace-1020665/