PPT Slide

Using the floor() function

in SELECT statements:

The floor( ) is the opposite of ceil( ), rounding

the value passed down to the next highest

integer:

SELECT FLOOR(123.323),

FLOOR(45),

FLOOR(-392),

FLOOR(-1.12)

FROM DUAL;FLOOR(123.323) FLOOR(45) FLOOR(-392) FLOOR(-1.12)------------- -------- ---------- -----------123 45 -392 -2

30

Previous slide

Next slide

Back to first slide

View graphic version