CONVERSION BETWEEN TIMESTAMPS AND SCNS

Two new SQL functions in 11g, SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN, convert SCNs to a corresponding timestamp

value and vice versa. The SCN_TO_TIMESTAMP SQL function lets you convert an SCN to a calendar time
(TIMESTAMP) value. Here’s an example:

SQL> SELECT current_scn, SCN_TO_TIMESTAMP(current_scn) FROM v$database;

CURRENT_SCN SCN_TO_TIMESTAMP(CURRENT_SCN)
————- ———————————–
6965956 13-AUG-13 02.15.16.000000000 AM

SQL>
The TIMESTAMP_TO_SCN function is the inverse of the SCN_TO_TIMESTAMP function. It converts a timestamp
to its corresponding SCN.

One comment

  1. I read a lot of interesting posts here. Probably you spend a
    lot of time writing, i know how to save you a
    lot of work, there is an online tool that creates readable, google
    friendly posts in minutes, just type in google – k2seotips unlimited content

    Like

    Reply

Leave a comment