How To Find SCN From Timestamp in Oracle

In this article we will discuss how to find SCN from Timestamp and vice versa in ORACLE.

Find SCN From Timestamp

SQL > Col scn for 999999
SQL > select timestamp_to_scn(to_timestamp(‘20-03-2020 17:10:00‘,’DD-MM-YYYY HH24:MI:SS’)) as scn from dual;

Output of the above query will be as below:


Find Timestamp From SCN

SQL > alter session set nls_date_format=’DD-MON-RRRR HH24:MI:SS’;
SQL > select scn_to_timestamp(921634) as timestamp from dual;

Output will be:

20-03-2020 17:10:00