Login     Register

        Contact Us     Search

XLeratorDB/engineering Online Documentation

SQL Server DEC2HEX function


 
Updated: 27 August 2010

Use DEC2HEX to convert a decimal number to hexadecimal.
Syntax
SELECT [wctEngineering].[wct].[DEC2HEX] (
   <@Number, float,>
 ,<@Places, float,>)
Arguments
@Number
is the decimal integer you want to convert. If @Number is negative, valid @Places values are ignored and DEC2HEX returns a 10-character (40-bit) hexadecimal number in which the most significant bit is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. @Number is an expression of type float or of a type that can be implicitly converted to float
@Places
The number of characters to use. If @Places is NULL, DEC2HEX uses the minimum number of characters necessary. @Places is useful for padding the return value with leading 0s (zeros). @Places is an expression of type float or of a type that can be implicitly converted to float
Return Types
varchar(4000)
Remarks
·         If @Number is less than -549,755,813,888 or @Number is greater than 549,755,813,887, DEC2HEX returns an error.
·         If @Number is negative, DEC2HEX ignores places and returns a 10-character hexadecimal number.
·         @Places is truncated to zero decimal places.
Examples

select
wct.DEC2HEX(-512, NULL)

This produces the following result
---------------------------
FFFFFFFE00
 
(1 row(s) affected)


select
wct.DEC2HEX((power(16.0000,10.0000)/2)-1, NULL)

This produces the following result
--------------------------
7FFFFFFFFF
 
(1 row(s) affected)


select
wct.DEC2HEX(100, 10)

This produces the following result
--------------------------
0000000064
 
(1 row(s) affected)


Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service