Oracle SCN與時間的互相轉換

1.SCN轉換成時間

select scn_to_timestamp(current_scn) from v$database;      

2.時間轉換成SCN

select timestamp_to_scn(sysdate) from v$database;      

select scn_to_timestamp(current_scn) from v$database;      

select timestamp_to_scn(sysdate) from v$database;