BOOLEAN
type
Applies to: Databricks SQL Databricks Runtime
Represents Boolean values.
Syntax
BOOLEAN
Limits
The type supports true and false values.
Literals
{ TRUE | FALSE }
Examples
> 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