Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t42(dt date);
declare
    d date;
begin
    dbms_stats.convert_raw_value('78780701183c3c', d);
    insert into t42 (dt) values (d);
    dbms_stats.convert_raw_value('799d0200183c3c', d);
    insert into t42 (dt) values (d);
    dbms_stats.convert_raw_value('78b80100183c3c', d);
    insert into t42 (dt) values (d);
    dbms_stats.convert_raw_value('78760701010101', d);
    insert into t42 (dt) values (d);
end;
/
1 rows affected

alter session set nls_date_format = 'DD-MM-YYYY HH24:MI:SS';
select dt, dump(dt) as dump1, dump(dt, 1016) as dump2 from t42;


DT
DUMP1
DUMP2


01-07-2020 23:59:59
Typ=12 Len=7: 120,120,7,1,24,60,60
Typ=12 Len=7: 78,78,7,1,18,3c,3c

00-02-2157 23:59:59
Typ=12 Len=7: 121,157,2,0,24,60,60
Typ=12 Len=7: 79,9d,2,0,18,3c,3c

00-01-2084 23:59:59
Typ=12 Len=7: 120,184,1,0,24,60,60
Typ=12 Len=7: 78,b8,1,0,18,3c,3c

01-07-2018 00:00:00
Typ=12 Len=7: 120,118,7,1,1,1,1
Typ=12 Len=7: 78,76,7,1,1,1,1

DT	DUMP1	DUMP2
01-07-2020 23:59:59	Typ=12 Len=7: 120,120,7,1,24,60,60	Typ=12 Len=7: 78,78,7,1,18,3c,3c
00-02-2157 23:59:59	Typ=12 Len=7: 121,157,2,0,24,60,60	Typ=12 Len=7: 79,9d,2,0,18,3c,3c
00-01-2084 23:59:59	Typ=12 Len=7: 120,184,1,0,24,60,60	Typ=12 Len=7: 78,b8,1,0,18,3c,3c
01-07-2018 00:00:00	Typ=12 Len=7: 120,118,7,1,1,1,1	Typ=12 Len=7: 78,76,7,1,1,1,1