How does one find Oracle timestamp from current SCN


Here is a quick way to find the current timestamp from the current SCN.

SQL> select to_char(CURRENT_SCN) from v$database;
TO_CHAR(CURRENT_SCN)
----------------------------------------
802487875289
SQL> select scn_to_timestamp(802487875289) from dual;
SCN_TO_TIMESTAMP(802487875289)
---------------------------------------------------------------------------
08-JAN-14 02.05.38.000000000 PM

SQL>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: