> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.
## Submitting Feedback
If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:
POST https://docs.firebolt.io/feedback
```json
{
"path": "/reference-sql/functions-reference/numeric/round",
"feedback": "Description of the issue"
}
```
Only submit feedback when you have something specific and actionable to report.
> Reference material for ROUND function
# ROUND
export const QueryWindow = ({content}) => {
const {sql, result} = content;
const [inited, setInited] = useState(false);
const buttonRef = useRef(null);
useEffect(() => {
if (!inited && buttonRef.current) {
runQuery(buttonRef.current, true);
setInited(true);
}
}, []);
return
Interactive SQL Playground 🔥
{sql}
The Firebolt playground server is currently unavailable. Using precomputed query results.
;
};
Rounds a value to a specified number of decimal places.
## Syntax
```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ROUND( [, ])
```
## Parameters
| Parameter | Description | Supported input types |
| :---------- | :------------------------------------------------------------------------------------------------------------------------------- | :-------------------- |
| `` | The value to be rounded | |
| `` | Optional. An `INTEGER` constant that defines the decimal range of the returned value. By default, `ROUND` returns whole numbers. | `INTEGER` |
## Return Types
`DOUBLE PRECISION`
## Rounding behavior
When rounding values that are exactly halfway between two possible results (for example, 1.5 or 2.5 when rounding to the nearest integer), `ROUND` uses different strategies depending on the data type:
* **DOUBLE PRECISION**: Uses banker's rounding (also called round half to even). Ties are rounded to the nearest even number. For example, both `1.5` and `2.5` round to `2` (the nearest even number).
* **NUMERIC**: Uses standard rounding (round half up). Ties are always rounded up. For example, `1.5` rounds to `2` and `2.5` rounds to `3`.
This behavior ensures that when working with floating point numbers, rounding errors don't accumulate in a particular direction over many operations.
## Example
The following example returns the rounded value of 5.4. Since there is no specification of the decimal range, the functions returns a whole number:
The following example rounds the value 5.6930 to 1 decimal place:
The following examples demonstrate the tie-breaking behavior for values exactly halfway between two results:
Notice how both `1.5` and `2.5` round to `2` (the nearest even number). This is banker's rounding behavior for `DOUBLE PRECISION` types.
With `NUMERIC` types, ties round up instead:
The same tie-breaking behavior applies when rounding to a specific number of decimal places:
Both `1.15` and `1.25` round to `1.2` when rounding to 1 decimal place, demonstrating banker's rounding.
With `NUMERIC` types at a specific decimal precision: