rint function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns expr rounded to a whole number as a DOUBLE.

Syntax 

rint(expr)

Arguments

  • expr: An expression that evaluates to a numeric.

Returns

A DOUBLE.

This function is a synonym for round(expr, 0).

Examples 

> SELECT rint(12.3456);
 12.0