ETL: ROUND

Round a numeric expression to the nearest integer using standard math rounding rules. Use ROUND for numeric formatting in ETL data pipelines.

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.