HEX

The HEX function returns a hexadecimal representation of a value.

Read syntax diagramSkip visual syntax diagram
>>-HEX--(--expression--)---------------------------------------><

expression
An expression that returns a value of any built-in data type other than a character or binary string with a length attribute greater than 16 336 or a graphic string with a length attribute greater than 8168.

The result of the function is a character string. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

The result is a string of hexadecimal digits, the first two digits represent the first byte of the argument, the next two digits represent the second byte of the argument, and so forth. If the argument is a datetime value, the result is the hexadecimal representation of the internal form of the argument.1

Start of changeIf the argument is not a graphic string, the actual length of the result is twice the length of the argument. If the argument is a graphic string, the actual length of the result is four times the length of the argument. If the data type of the result is varying length, the length is limited to the maximum length of the data type. The length of the argument is the value that would be returned if the argument were passed to the LENGTH scalar function. For more information, see LENGTH.End of change

The data type and length attribute of the result depends on the attributes of the argument:

The length attribute of the result cannot be greater than the product-specific length attribute of CHAR or VARCHAR. See Table 3 for more information.

The CCSID of the string is the default SBCS CCSID at the current server.

Example

1 This hexadecimal representation for DATE, TIMESTAMP, and NUMERIC data types is different from other database products because the internal form for these data types is different.