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).

Syntax

rint(expr)

Arguments

• expr: An expression that evaluates to a numeric.

Returns

A DOUBLE.

Examples

> SELECT rint(12.3456);
 12.0

Related functions

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