Database SCN number some time is very important
1) particularly when you are doing rman recovery
2) Filling gaps of archive logs between primary server and Physical standby server. Below SQL queries will give SCN for particular date and date to get SCN.
SQL>select current_scn from v$database; 7705798324 SQL> select timestamp_to_scn(to_timestamp('24/09/2012 14:24:54','DD/MM/YYYY HH24:MI:SS')) as scn from dual; SCN ---------- 7705798324 SQL> SQL> select scn_to_timestamp(7705798324) as timestamp from dual; 24-SEP-12 02.24.52.000000000 PM