FLOOR returns largest integer equal to or less than n . This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. The function returns the same datatype as the numeric datatype of the argument.

What is Ceil and floor in MySQL?

MySQL FLOOR() Function The FLOOR() function returns the largest integer value that is smaller than or equal to a number. Note: Also look at the ROUND(), CEIL(), CEILING(), TRUNCATE(), and DIV functions.

What is meant by floor function?

In mathematics and computer science, the floor function is the function that takes as input a real number x, and gives as output the greatest integer less than or equal to x, denoted floor(x) or ⌊x⌋.