ROUND

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.