The floor functions allows you to round down any number to the nearest integer.
For example:
|
floor(6.02) |
would return 6 |
|
floor(7.789) |
would return 7 |
See Ceil to round numbers up to the nearest integer.
See Round to round a number to a particular number of decimal places.
Floor – Oracle SQL Function