rint function

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