Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/data-types/boolean-type below:

BOOLEAN type | Databricks Documentation

Applies to: Databricks SQL Databricks Runtime

Represents Boolean values.

BOOLEAN

The type supports true and false values. A BOOLEAN can be NULL as well. See Logical operators for more information.

{ TRUE | FALSE }

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

• cast function
• Logical operators

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4