Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

FLOOR(x) gets the largest integer less than or equal to x

The following example uses FLOOR() to display the absolute value of 5.8 and -5.2, respectively: SQL> SELECT FLOOR(5.8), FLOOR(-5.2) FROM dual; FLOOR(5.8) FLOOR(-5.2) ---------- -----------          5          -6 SQL>