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

> Round a numeric expression to a specified number of decimal places. Use ROUND_TO for precision control and formatting in ETL pipeline expressions.

## Description

Rounds the expression to a fixed number of decimal digits.

## Syntax

ROUND\_TO(numeric\_expression, digits \[, mode])

Arguments

*numeric\_expression* - the value to round (float or double)

*digits* - the number of digits to preserve (int)

*mode* (optional) - [round mode](https://docs.oracle.com/javase/7/docs/api/constant-values.html#java.math)

## Examples

`ROUND_TO(3.14151976,3)` returns 3.142

`ROUND_TO(42.1,-1)` returns 40.0

`ROUND_TO(3.5,0,4)` returns 4.0

## Return value datatype

The same as numeric\_expression's data type.

## Impact of null value

If numeric\_expression is null, returns null. If digits is null, an error is raised.