By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
15 rows affected
| VALUE | DIGITS | ROUNDED_VALUE | FORMATTED_VALUE |
|---|---|---|---|
| 1278 | 2 | 1300 | 1300 |
| 1234.56789 | 2 | 1200 | 1200 |
| 1234.56789 | 4 | 1235 | 1235 |
| 1234.56789 | 5 | 1234.6 | 1234.6 |
| 1234.56789 | 6 | 1234.57 | 1234.57 |
| 1000 | 2 | 1000 | 1000 |
| 1000 | 5 | 1000 | 1000.0 |
| .1234 | 2 | .12 | 0.12 |
| .1234 | 8 | .1234 | 0.12340000 |
| 3 | 2 | 3 | 3.0 |
| 3.12345 | 2 | 3.1 | 3.1 |
| 0 | 2 | 0 | 0.0 |
| -3.12345 | 2 | -3.1 | -3.1 |
| -.000012345 | 3 | -.0000123 | -0.0000123 |
| 99.997 | 2 | 100 | 100 |