Ravi Kamra asked 1 year ago
Title : How to convert SCN timestamp and vice versa?

Question :

How to convert SCN timestamp and vice versa?

1 Answers
Kumar HarshKumar Harsh Staff answered 1 year ago

scn_to_timestamp() and timestamp_to_scn()

Example:

select scn_to_timestamp (845396) as timestamp from dual;

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.