Oracle/PLSQL: Floor Function
In Oracle/PLSQL, the floor function returns the largest integer value that is equal to or less than a number.
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 8i, Oracle 9i, Oracle 10g, Oracle 11g
For Example:
floor(5.9) would return 5 floor(34.29) would return 34 floor(-5.9) would return -6