FLOOR(a) is an arithmetic function that calculates the largest integer value that is smaller than or equal to the expression a (a number).

The result is a fixed point number with 0 decimal places.

An error message is output if it is not possible to represent the result of FLOOR(a) as a fixed point number.

Result of the FLOOR(a) Function

a is the NULL value

NULL value

a is a special NULL value

Special NULL value