?::
(triple colon sign) operator
Applies to: Databricks Runtime 15.3 and later
Casts the value expr
to the target data type type
with error toleration. This operator is a synonym for try_cast function.
CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseUpdated Oct 11, 2024
?::
(triple colon sign) operator?::
(triple colon sign) operator Applies to: Databricks Runtime 15.3 and later
Casts the value expr
to the target data type type
with error toleration. This operator is a synonym for try_cast function.
> SELECT '20'?::INTEGER;
20
> SELECT 'twenty'?::INTEGER;
NULL
> SELECT typeof(NULL?::STRING);
string