Oracle FLOOR Function Explained: Usage & Examples

In Oracle database, the FLOOR function is used to return the largest integer that is less than or equal to the specified number. The syntax of this function is as follows:

Round down the number to the nearest whole number.

The number needs to be rounded to the nearest whole number.

For example, if the number to be rounded down is 2.6, FLOOR(2.6) will result in 2; if the number to be rounded down is -3.8, FLOOR(-3.8) will result in -4. This way, the FLOOR function helps users round floating-point numbers down to integers.