Getting started
User guides
Administration guides
Reference guides
Resources
Updated May 13, 2022
Send us feedback
BOOLEAN
Represents Boolean values.
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 (Databricks SQL)