Conversion

TO_HEX

DuckDB

Mengkonversi integer atau blob ke representasi hexadecimal string.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

TO_HEX(value)

valueINTEGER/BIGINT/BLOBwajib

Nilai yang akan dikonversi ke hex

SQL

1 SELECT TO_HEX(255) AS hex;

255 ke hexadecimal.

Hasil

SQL

1 SELECT
2   TO_HEX(16777215) AS white,
3   TO_HEX(16711680) AS red;

Color values ke hex.

Hasil

ffffff | ff0000

SQL

1 SELECT
2   '#' || UPPER(LPAD(TO_HEX(color_value), 6, '0')) AS color_code
3 FROM colors;

Format sebagai color code.

SQL

1 SELECT TO_HEX(MD5('hello')::BLOB) AS md5_hex;

MD5 hash ke hex string.

1	SELECT
2	'#' \|\| UPPER(LPAD(TO_HEX(color_value), 6, '0')) AS color_code
3	FROM colors;