该内容来源官网：

http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions161.htm#BABEHBCB

 

其用法很简单

scn_to_timestamp(number)，其中number指的是系统当前生产的SCN

 

文档中NOTE部分提到一个内容值得注意：

The association between an SCN and a timestamp when the SCN is generated is remembered by the database for a limited period of time. This period is the maximum of the auto-tuned undo retention period, if the database runs in the Automatic Undo Management mode, and the retention times of all flashback archives in the database, but no less than 120 hours. The time for the association to become obsolete elapses only when the database is open. An