Find Convert Oracle Timestamp to SCN and SCN to timestamp


How to get current SCN

SELECT TO_CHAR(CURRENT_SCN) FROM V$DATABASE;

How to find SCN from timestamp

select timestamp_to_scn( to_date('2025-05-12 08:00:00', 'YYYY-MM-DD HH24:MI:SS')) from dual ;

How to find timestamp from SCN

SELECT SCN_TO_TIMESTAMP(5975060381143) from dual;







Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment