Get started
Load & manage data
Work with data
Administration
Reference & resources
Updated Mar 22, 2023
Send us feedback
rint
Applies to: Databricks SQL Databricks Runtime
Returns expr rounded to a whole number as a DOUBLE.
expr
rint(expr)
expr: An expression that evaluates to a numeric.
A DOUBLE.
This function is a synonym for round(expr, 0).
round(expr, 0)
> SELECT rint(12.3456); 12.0
ceil function
ceiling function
floor function
round function