Oracle SQL - Function FLOOR function

Introduction

FLOOR function returns the floor value: next lowest integer below number.

FLOOR returns the integer below the number, regardless of whether positive or negative.

Demo

SQL>
SQL>-- w  ww.  jav a 2 s  .  c o  m
SQL> drop table my_table;

Table dropped.

SQL> CREATE TABLE my_table (
  2      LINENO NUMBER(2) not null,
  3      VALUE NUMBER(6,2) not null
  4  );
SQL>
SQL> insert into my_table values(1,1.2);
SQL> insert into my_table values(2,123.34);
SQL> insert into my_table values(3,-12.2);
SQL> insert into my_table values(4,100);
SQL> insert into my_table values(5,48);
SQL> insert into my_table values(6,-90);
SQL> insert into my_table values(7,0.19);
SQL>
SQL> SELECT lineno, value, ROUND(value), TRUNC(value), CEIL(value),
  2  FLOOR(value)
  3  FROM my_table;

   LINENO |     VALUE | ROUND(VALUE) | TRUNC(VALUE) | CEIL(VALUE) | FLOOR(VALUE)
--------- | --------- | ------------ | ------------ | ----------- | ------------
 00001.00 |  00001.20 |     00001.00 |     00001.00 |    00002.00 |     00001.00
 00002.00 |  00123.34 |     00123.00 |     00123.00 |    00124.00 |     00123.00
 00003.00 | -00012.20 |    -00012.00 |    -00012.00 |   -00012.00 |    -00013.00
 00004.00 |  00100.00 |     00100.00 |     00100.00 |    00100.00 |     00100.00
 00005.00 |  00048.00 |     00048.00 |     00048.00 |    00048.00 |     00048.00
 00006.00 | -00090.00 |    -00090.00 |    -00090.00 |   -00090.00 |    -00090.00
 00007.00 |  00000.19 |     00000.00 |     00000.00 |    00001.00 |     00000.00

7 rows selected.

SQL>