:: (colon colon sign) operator

Applies to: Databricks SQL Databricks Runtime

Casts the value expr to the target data type type. This operator is a synonym for cast function.

Syntax

expr :: type

Arguments

• expr: Any castable expression.

Returns

The result is type type.

Examples

> SELECT '20'::INTEGER;
 20

> SELECT typeof(NULL::STRING);
 string

Related functions

• cast function
• try_cast function