FLOOR(a) 
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.
If it is not possible to represent the result of FLOOR(a) as a fixed point number, then an error message is generated.
a |
Result of the FLOOR(a) function |
|---|---|
a is a NULL value |
NULL value |
a is a special NULL value |
Special NULL value |