boolean function

Applies to: Databricks SQL Databricks Runtime

Casts expr to boolean. This function is a synonym for CAST(expr AS binary). See cast function for details.

boolean(expr)

• expr: Any expression that can be cast to BOOLEAN.

A BOOLEAN.

> SELECT boolean(1);
 true
> SELECT boolean(0);
 false

> SELECT boolean(2);
 true

• cast function