FLOOR returns the largest integer not greater than argument. The return data type is the same as the argument.
Syntax
FLOOR ( expression )
Semantics
expression |
is an expression of type INTEGER or DOUBLE PRECISION. |
Examples
FLOOR(-42.8)
Result: -43