Oracle/PLSQL: Floor Function
In Oracle/PLSQL, the floor function returns the largest integer value that is equal to or less than a number.
Syntax
The syntax for the floor function is:
floor( number )
number is the value used to determine the largest integer value that is equal to or less than a number.
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
| floor(5.9) | would return 5 |
| floor(34.29) | would return 34 |
| floor(-5.9) | would return -6 |