Conversion

TO_BINARY

SnowflakeSnowflake

Mengkonversi string ke tipe BINARY.

Tipe hasil: BINARYDiperbarui: 6 Jan 2026

Syntax

SQL
TO_BINARY(expression [, format])

Parameter

expressionVARCHARwajib

String untuk dikonversi

formatVARCHARopsional

Format: HEX, BASE64, UTF-8

Default: HEX

Contoh Penggunaan

Hex to Binary

SQL
1SELECT TO_BINARY('48656C6C6F', 'HEX') as bin;

Konversi hex ke binary.

Base64 to Binary

SQL
1SELECT TO_BINARY('SGVsbG8=', 'BASE64') as bin;

Decode base64.

Fungsi Terkait