Q: How to convert an SCN to timestamp in Oracle?

A: Use the SCN_TO_TIMESTAMP function, for example:


  • select scn_to_timestamp(2564532) from dual;



Q: Is there a timestamp to SCN function?

A: Yes, here is an example:


  • SQL> select timestamp_to_scn('16-JUL-12 05.45.14') from dual;


    TIMESTAMP_TO_SCN('16-JUL-1205.45.14')
    -------------------------------------
    2545944