Conversion

TO_BOOLEAN

SnowflakeSnowflake

Mengkonversi nilai ke tipe BOOLEAN.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL
TO_BOOLEAN(expression)

Parameter

expressionVARCHAR/NUMBERwajib

Nilai untuk dikonversi

Contoh Penggunaan

String to Boolean

SQL
1SELECT TO_BOOLEAN('yes') as bool;

Konversi 'yes' ke TRUE.

Hasil
TRUE

Number to Boolean

SQL
1SELECT TO_BOOLEAN(1) as bool;

Non-zero = TRUE.

Hasil
TRUE

Fungsi Equivalen di Database Lain