scn  与 timestamp的相互转换

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE<wbr><wbr><wbr> 11.2.0.1.0<wbr><wbr><wbr><wbr><wbr> Production<br> TNS for Linux: Version 11.2.0.1.0 - Production<br> NLSRTL Version 11.2.0.1.0 - Production<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr></wbr>

SQL> select timestamp_to_scn(sysdate) from dual;

TIMESTAMP_TO_SCN(SYSDATE)
-------------------------
<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 1061893</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

SQL> select scn_to_timestamp(1061893) from dual;

SCN_TO_TIMESTAMP(1061893)
---------------------------------------------------------------------------
05-JAN-13 11.23.36.000000000 AM

SQL>

<wbr></wbr>

<wbr></wbr>

oracle online doc ：sql reference

1》timestamp to scn

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions176.htm

2》scn to timestamp

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions142.htm

<wbr></wbr>

<wbr></wbr>