:: (colon colon sign) operator

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