SAP SQL Anywhere

Question

The title says it all. HEXTOINT can only convert integers up to 32 bit. I need to convert a 48 bit-long number from hex to decimal and viceversa.

Accepted Answer

5

BEGIN
DECLARE @hex VARCHAR ( 100 );
DECLARE @bigint BIGINT;
SET @hex = '7048860DDF79';
EXECUTE IMMEDIATE STRING ( 'SET @bigint = CAST ( 0x', @hex, ' AS BIGINT )' );
SELECT @bigint;
END;

@bigint
123456789012345

permanent link

answered 23 Feb '11, 14:17

Breck Carter
32.5k●541●727●1050
accept rate: 20%

Thanks for the fast response!

(23 Feb '11, 14:54) Sergio

flat view

Answer 2

Another option, inspired by Breck's solution:

   create or replace function hextobigint( @in varchar(16) )
    returns unsigned bigint
    begin
      declare @result unsigned bigint;
      set @result = (select cast(v1 as unsigned bigint) 
          from openstring(value '0x' || @in) with (v1 binary(8)) 
                   option(hexadecimal on) as x);
      return @result;
    end
    go
    select hextobigint( '7048860DDF79')
    go

SAP SQL Anywhere

Convert a hexadecimal string to BIGINT on SA10

Follow this question

Related questions