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