Description
Rounds the expression up or down to the nearest integer according to standard math rules.
Syntax
ROUND(numeric_expression)
Examples
ROUND(1.3) returns 1
ROUND(1.5) returns 2
Return value datatype
- If the result type is float, the returned value is rounded to an integer.
- If the result type is double, the returned value is rounded to a long number.
Impact of null value
If input is null, job fails.