BOOLEAN type

Applies to: Databricks SQL Databricks Runtime

Represents Boolean values.

BOOLEAN

The type supports true and false values.

{ TRUE | FALSE }

> SELECT true;
  TRUE

> SELECT typeof(false);
  BOOLEAN

> SELECT CAST(0 AS BOOLEAN);
  FALSE

> SELECT CAST(-1 AS BOOLEAN);
  TRUE

> SELECT CAST('true' AS BOOLEAN);
  TRUE

• cast function