A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Functions: Datatype Conversion Functions

biginttohex()

The Datatype Conversion Function biginttohex() returns the platform specific hexadecimal value of a digit. The function biginttohex is available in ASE® starting with version 15.0.

Syntax of the datatype conversion function biginttohex()

    biginttohex( integer_expression )
    

The parameter of the datatype conversion function biginttohex()

integer_expression
The parameter "integer_expression" is a placeholder for an integer value, which can be converted into its platform dependent hexadecimal value. The return value is displayed without the "0x".

Example for the datatype conversion function biginttohex()

    select biginttohex(-9223372036854775808)
go
-----
8000000000000000

See also:

ASE T-SQL - Aggregate Functions,
bintostr(),
cast(),
convert(),
Datatype Conversion Functions,
explicit conversion,
hextobigint(),
hextoint(),
implicit conversions,
inttohex().