Skip to contents

DuckDB function hex

Source: R/duckdb-funs.R
hex.Rd

  • hex(string = VARCHAR): Converts the string to hexadecimal representation.

  • hex(value = BIGNUM), hex(value = BIGINT), hex(value = UBIGINT), hex(value = HUGEINT), hex(value = UHUGEINT): Converts the value to VARCHAR using hexadecimal representation.

  • hex(blob = BLOB): Converts blob to VARCHAR using hexadecimal encoding.

Usage

hex(value)

Arguments

value

BIGNUM | BIGINT | UBIGINT | HUGEINT | UHUGEINT

Value

VARCHAR

Overloads

  • hex(string = VARCHAR)

  • hex(value = BIGNUM)

  • hex(blob = BLOB)

  • hex(value = BIGINT)

  • hex(value = UBIGINT)

  • hex(value = HUGEINT)

  • hex(value = UHUGEINT)

SQL examples

hex('Hello')
hex(42)
hex('\xAA\xBB'::BLOB)

See also

Other blob: decode(), encode(), from_base64(), md5(), md5_number(), octet_length(), or–or, repeat(), sha1(), sha256(), to_base64(), unbin(), unhex()

Other numeric: bin(), bit_length(), formatReadableDecimalSize(), format_bytes(), greatest(), least(), len(), parse_formatted_bytes(), to_base()

Other string: array_extract(), ascii(), bar(), bin(), bit_length(), chr(), concat(), concat_ws(), contains(), format(), formatReadableDecimalSize(), format_bytes(), from_base64(), greatest(), hash(), ilike_escape(), instr(), least(), left(), left_grapheme(), len(), length_grapheme(), like_escape(), list_slice(), lower(), lpad(), ltrim(), md5(), md5_number(), nfc_normalize(), not_ilike_escape(), not_like_escape(), or–or, parse_dirname(), parse_dirpath(), parse_filename(), parse_formatted_bytes(), parse_path(), prefix(), printf(), repeat(), replace(), reverse(), right(), right_grapheme(), rpad(), rtrim(), sha1(), sha256(), starts_with(), string_split(), strip_accents(), strlen(), substring(), substring_grapheme(), suffix(), to_base(), to_base64(), translate(), trim(), unbin(), unhex(), unicode(), upper(), url_decode(), url_encode()