ROUND
All functions > MATH > ROUND
Rounds a number to the nearest integer or to a specified number of decimal places.
Syntax
ROUND(expr, digits)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
number | DOUBLE | Yes | The number to round |
decimal_places | EMPTY | Yes | Optional number of decimal places (default: 0) |
Returns
DOUBLE - Rounded number
Notes
- Uses "round half up" strategy (0.5 rounds up to 1)
- Negative decimal_places rounds to tens, hundreds, etc.
ROUND(123.456, 2) = 123.46ROUND(123.456, -1) = 120.0- Returns NULL if the input is NULL