Question

Difference between CEIL and FLOOR functions?

Answer 1

The ceil function returns the smallest integer greater than/equal to the argument whereas the floor returns the greatest integer less than/equal to the argument.

For example : ceil(4.4) returns 5 whereas floor(4.4) returns 4.