All Forums Database
lijianguonew 5 posts Joined 07/14
27 Jul 2014
hexadecimal--->decimal

hexadecimal--->decimal 
 
id   16hex   
aaa  28E1
 
 
Result:
id    decimal 
aaa   10465

Tags:
dnoeth 4628 posts Joined 11/04
27 Jul 2014

It would be nice to actually pose a question.
16hex = binary|string?
result = binary|string|numeric?
 
 

Dieter

krishaneesh 140 posts Joined 04/13
28 Jul 2014
Select '28E1',((((((Index('0123456789abcdef',Substr('28E1',
        1,1)) -1) * 16 ) + ((Index('0123456789abcdef',Substr('28E1',
        2,1)) -1) ))* 16) + ((Index('0123456789abcdef',Substr('28E1',
        3,1)) -1) ))* 16) + Index('0123456789abcdef',Substr('28E1',
        4,1)) -1

 

amerbaig 7 posts Joined 07/11
25 Aug 2014

SELECT to_number( '28E1', 'xxxxx' )  -- hex to decimal

You must sign in to leave a comment.