int
function
Applies to: Databricks SQL
Databricks Runtime
Casts the value expr
to INTEGER. This function is a synonym for CAST(expr AS INTEGER)
.
int(expr)
expr
: Any expression which is castable to INTEGER.
An INTEGER.
> SELECT int(-5.6);
-5
> SELECT int('5');
5