By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| num | unrounded | odbc_truncated | modulusced | floored | rounderood | stuffed | lefted | substringed |
|---|---|---|---|---|---|---|---|---|
| 1.444 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
| 1.888 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
| 123456.111 | 123456.1 | 123456.1 | 123456.1 | 123456.1 | 123456.1 | 123456.1 | 123456.1 | 123456.1 |
| 123456.999 | 123456.9 | 123456.9 | 123456.9 | 123456.9 | 123456.9 | 123456.9 | 123456.9 | 123456.9 |