> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.