Syntax
FLOOR(<number>;<number>)
Description
Rounds a number down, toward 0 (zero). The second value is the significance.
Examples
| Column1 | FLOOR() returns |
|---|
| 123.45 | 123 |
| 37.888 | 37 |
| -5.5 | -6 |
Add a significance value to round down from a specific decimal position.
| Column1 | FLOOR(<column1>;3) |
|---|
| 123.456789 | 123.456 |