Skip to main content

TO_BOOLEAN

Converts a value to BOOLEAN data type.

Syntax

TO_BOOLEAN( <expr> )

Examples

SELECT TO_BOOLEAN('true');

┌────────────────────┐
│ to_boolean('true')
├────────────────────┤
true
└────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today