The FLOOR function rounds the specified number down, and returns the largest number that is less than or equal to the specified number.

The specified number must be a DOUBLE PRECISION number.

The returned value is the largest (closest to positive infinity) double floating point value that is less than or equal to the specified number. The returned value is equal to a mathematical integer. The data type of the returned value is a DOUBLE PRECISION number.