rint function

Applies to: Databricks SQL Databricks Runtime

Returns expr rounded to a whole number as a DOUBLE. This function is a synonym for round(expr, 0).

rint(expr)

• expr: An expression that evaluates to a numeric.

A DOUBLE.

> SELECT rint(12.3456);
 12.0

• ceil function
• ceiling function
• floor function
• round function