Scn to timestamp and viceversa - Oracle Database Script. -- Get current scn value: select current_scn from v$database; -- Get scn value at particular time: select timestamp_to_scn('19-JAN-08:22:00:10') from dual; -- Get timestamp from scn: select scn_to_timestamp(224292)from dual;
-- Get current scn value: select current_scn from v$database; -- Get scn value at particular time: select timestamp_to_scn('19-JAN-08:22:00:10') from dual; -- Get timestamp from scn: select scn_to_timestamp(224292)from dual;