Share via

:: (colon colon sign) operator

  • Article

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

SQL 
> SELECT '20'::INTEGER;
 20

> SELECT typeof(NULL::STRING);
 string