ROUND
Rounds the given input to a given number of decimal places.
Syntax
ROUND(X [, D])
Arguments
X
Type: numeric
A numeric value.
D
Type: bigint
Default: 0
(Optional) The number of decimal places to keep.
If omitted, the precision defaults to 0 and X is rounded to the nearest integer.
Returns
Type: same as input X
X rounded to D decimal places.
Examples
| X | D | Output |
|---|---|---|
| 1.1 | 1.0 | |
| -1.1 | -1.0 | |
| 1.9 | 2.0 | |
| -1.9 | -2.0 | |
| 1 | 1 | |
| 1 | 5 | 1 |
| 1.23 | 1 | 1.2 |
| 1 + 1 | 2 | |
| 0 | 0 | |
| -1 | -1 |