set serveroutput on
declare
min_date date;
max_date date;
begin
dbms_stats.convert_raw_value('&low_value',min_date);
dbms_stats.convert_raw_value('&high_value',max_date);
dbms_output.put_line('the min date is '||min_date);
dbms_output.put_line('the max date is '||max_date);
end;
/
--------------------
set serveroutput on
declare
min_date date;
max_date date;
begin
dbms_stats.convert_raw_value('78740616010101',min_date);
dbms_stats.convert_raw_value('78740616010101',max_date);
dbms_output.put_line('the min date is '||min_date);
dbms_output.put_line('the max date is '||max_date);
end;
/
----------------
select to_timestamp(
to_char( to_number( substr( p_str, 1, 2 ), 'xx' ) - 100, 'fm00' ) ||
to_char( to_number( substr( p_str, 3, 2 ), 'xx' ) - 100, 'fm00' ) ||
to_char( to_number( substr( p_str, 5, 2 ), 'xx' ), 'fm00' ) ||
to_char( to_number( substr( p_str, 7, 2 ), 'xx' ), 'fm00' ) ||
to_char( to_number( substr( p_str, 9, 2 ), 'xx' )-1, 'fm00' ) ||
to_char( to_number( substr( p_str,11, 2 ), 'xx' )-1, 'fm00' ) ||
to_char( to_number( substr( p_str,13, 2 ), 'xx' )-1, 'fm00' ), 'yyyymmdd hh24miss' )
from (select '&raw_timestamp' p_str from dual);
----------------
set serverout on
declare
d1 date;
begin
dbms_stats.convert_raw_value(hextoraw('78740616010101'),d1);
dbms_output.put_line('DATE: '||to_char(d1,'yyyy-mm-dd hh24:mi:ss'));
end;
/
