Oracle FLOOR() Function

The Oracle (PL/SQL) FLOOR() function returns the next lowest integer value by rounding down the specified number, if necessary. In other words, it rounds the fraction DOWN of the given number.

Syntax

FLOOR(x)

Parameters

Return Value

Returns the next lowest integer value by rounding DOWN the specified number, if necessary.

Example 1:

The example below shows the usage of FLOOR() function.

FLOOR(23)
Result: 23

FLOOR(23.3)
Result: 23

FLOOR(23.8)
Result: 23

FLOOR(-23)
Result: -23

FLOOR(-23.3)
Result: -24

FLOOR(-23.8)
Result: -24

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to round the fraction DOWN for all records of column x.

SELECT Sample.*, 
FLOOR(x) AS FLOOR_Value 
FROM Sample;

This will produce the result as shown below: