系统时间与SCN之间的转换: SQL> select timestamp_to_scn(sysdate) from dual; TIMESTAMP_TO_SCN(SYSDATE) ------------------------- 1908215 SQL> select scn_to_timestamp(1908215) from dual; SCN_TO_TIMESTAMP(1908215) --------------------------------------------------------------------------- 22-FEB-16 02.28.14.000000000 PM
原文:http://blog.csdn.net/ghostliming/article/details/50719458