Conversion
Snowflake
TO_BINARY
Mengkonversi string ke tipe BINARY.
Tipe hasil:
BINARYDiperbarui: 6 Jan 2026Syntax
SQL
TO_BINARY(expression [, format])Parameter
expressionVARCHARwajib
String untuk dikonversi
formatVARCHARopsional
Format: HEX, BASE64, UTF-8
Default: HEX
Contoh Penggunaan
Hex to Binary
SQL
1 SELECT TO_BINARY('48656C6C6F', 'HEX') as bin;
Konversi hex ke binary.
Base64 to Binary
SQL
1 SELECT TO_BINARY('SGVsbG8=', 'BASE64') as bin;
Decode base64.