Pular para o conteúdo principal
Última atualização em

BOOLEAN type

Applies to: check marked yes Databricks SQL check marked yes 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
Nesta página