_____________________________________________________________________________________

TIMESTAMP AND SCN (SYSTEM CHANGE NUMBER)
========================================

SYS@orcl> select value from V$NLS_PARAMETERS where parameter = 'NLS_TIMESTAMP_FORMAT';
VALUE
----------------------------------------------------------------
DD.MM.RR HH24:MI:SSXFF


SYS@orcl> select systimestamp from dual;
SYSTIMESTAMP
---------------------------------------------------------------------------
03.11.15 13:23:43,635899 +01:00


SYS@orcl> select to_char(timestamp_to_scn('03.11.15 11:00:00,000000')) "SCN" from dual;
SCN
----------------------------------------
4795315


SYS@orcl> select scn_to_timestamp('4795315') "TS" from dual;
TS
---------------------------------------------------------------------------
03.11.15 10:59:58,000000000


SYS@orcl> select to_char(to_date(2438937-1,'J'),'YYYY-MM-DD') "DATE" from dual;
DATE
----------
1965-06-24


_____________________________________________________________________________________
_____________________________________________________________________________________