Ravi Kamra asked 2 years 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 2 years 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.