How to convert scn to a timestamp in Oracle

convert scn to a timestamp

Oracle includes built-in features that allow you to convert scn into timestamp or timestamp to SCN. SCN_TO_TIMESTAMP accepts as an argument a number which evaluates to a system number (SCN) and returns the approximate timestamp associated. This function can be used to find the approximate timestamp associated an SCN. Oracle provides two packages, TIMESTAMP_TO_SCN and SCN_TO_TIMESTAMP. convert scn … Read more