This content has been marked as final. Show 2 replies
select trim(to_char(1000, 'xxxxxxxxxxxxx')) as "HEX", /* DECIMAL to HEX */ to_number('3e8','xxxxxxxxxxxxx') as "DECIMAL" /* HEX to DECIMAL */ from dual;
for the Hex-Number-conversion see:
[url http://psoug.org/snippet/Convert-Hex-to-Decimal-Decimal-to-Hex_78.htm] self-defined Conversion-Functions
What number format do you have? YYYMMDD
Or is there a Date corresponding to 1 and a number n represent the date n-1 days after day 1?
Please describe further.