`rint` function

Applies to: check marked yes 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