TO_BOOLEAN

This function isn’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.

Syntax

TO_BOOLEAN( <expr> )

Converts and returns the boolean value of the input. For null input, output is also NULL Support datatype: INT/DOUBLE/VARCHAR/BOOLEAN

> select to_boolean('1')
true

String Conversion

Strings converted to TRUE: 'true', 't', 'yes', 'on', '1'.

Strings converted to FALSE: 'false', 'f', 'no', 'off', '0'.

All other text strings cannot be converted to Boolean values.

Numeric Conversion

Zero (0) is converted to FALSE.

One (1) is converted to TRUE.

Any non-zero value other than 1 is converted to FALSE.

Syntax