Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the largest integer not greater than the given number.
FLOOR( numeric-expression )
The value to be truncated, typically a fixed numeric type with non-zero scale or an approximate numeric type (DOUBLE,
REAL, or FLOAT).
This function converts its arguments to DOUBLE, and performs the computation in double-precision floating-point arithmetic.
The following statement returns a Floor value of 123:
SELECT FLOOR (123);
SELECT FLOOR (123.45);
The following statement returns a Floor value of -124:
SELECT FLOOR (-123.45);