Conversion
Snowflake
TO_BOOLEAN
Mengkonversi nilai ke tipe BOOLEAN.
Tipe hasil:
BOOLEANDiperbarui: 6 Jan 2026Syntax
SQL
TO_BOOLEAN(expression)Parameter
expressionVARCHAR/NUMBERwajib
Nilai untuk dikonversi
Contoh Penggunaan
String to Boolean
SQL
1 SELECT TO_BOOLEAN('yes') as bool;
Konversi 'yes' ke TRUE.
Hasil
TRUE
Number to Boolean
SQL
1 SELECT TO_BOOLEAN(1) as bool;
Non-zero = TRUE.
Hasil
TRUE