# FLOOR for negative value : FLOOR « Numerical Math Functions « Oracle PL/SQL Tutorial

```SQL>
SQL> -- create demo table
SQL> create table myTable(
2    id           NUMBER(2),
3    value        NUMBER(6,2)
4  )
5  /

Table created.

SQL>
SQL> -- prepare data
SQL> insert into myTable(ID,  value)values (1,9)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (2,2.11)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (3,3.44)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (4,-4.21)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (5,10)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (6,3)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (7,-5.88)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (8,123.45)
2  /

1 row created.

SQL> insert into myTable(ID,  value)values (9,98.23)
2  /

1 row created.

SQL>
SQL> select * from myTable
2  /

ID      VALUE
---------- ----------
1          9
2       2.11
3       3.44
4      -4.21
5         10
6          3
7      -5.88
8     123.45
9      98.23

9 rows selected.

SQL>
SQL>
SQL> SELECT id, value,FLOOR(value) FROM myTable
2  /

ID      VALUE FLOOR(VALUE)
---------- ---------- ------------
1          9            9
2       2.11            2
3       3.44            3
4      -4.21           -5
5         10           10
6          3            3
7      -5.88           -6
8     123.45          123
9      98.23           98

9 rows selected.

SQL>
SQL>
SQL>
SQL> -- clean the table
SQL> drop table myTable
2  /

Table dropped.

SQL>
SQL>
```
 14.12.FLOOR 14.12.1. FLOOR(x) gets the largest integer less than or equal to x. 14.12.2. Use FLOOR function to get the flooring value 14.12.3. FLOOR for negative value 14.12.4. FLOOR(5.8) 14.12.5. FLOOR(-5.2) 14.12.6. select round(345.678), ceil(345.678), floor(345.678) 14.12.7. Use floor to get the number of weeks 14.12.8. Use floor and mod to get the number of days