ROUND
Syntax
<round-expression> := 'ROUND(' <Number> ')'
Since
2.0
Return-type
Integer
Description
The function ROUND returns the closest integer to the argument. The result is rounded to an integer by adding 1/2, taking the floor of the result, and casting the result to type integer.
If the argument is NULL, the function returns NULL.
Examples
ROUND( 0.5 )
= 1
ROUND( 0.4 )
= 0
ROUND( NULL )
= NULL
See also
CEIL, FLOOR
