Get started
Load & manage data
Work with data
Administration
Reference & resources
Updated Mar 24, 2023
Send us feedback
int
Applies to: Databricks SQL Databricks Runtime
Casts the value expr to INTEGER.
expr
int(expr)
expr: Any expression which is castable to INTEGER.
An INTEGER.
This function is a synonym for CAST(expr AS INTEGER).
CAST(expr AS INTEGER)
> SELECT int(-5.6); 5 > SELECT int('5'); 5
cast function