BOOLEAN
type
Applies to: Databricks SQL
Databricks Runtime
Represents Boolean values.
Syntax
BOOLEAN
Limits
The type supports true
and false
values.
A BOOLEAN
can be NULL
as well.
See Logical operators for more information.
Literals
{ TRUE | FALSE }
Examples
SQL
> 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
> SELECT CAST(NULL AS BOOLEAN);
NULL