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 FLOOR function comprises part of optional SQL/2008 language feature T621, "Enhanced numeric functions".
The following statement returns a Floor value of 123:
SELECT FLOOR (123);
The following statement returns a value of 123:
SELECT FLOOR (123.45);
The following statement returns a value of -124:
SELECT FLOOR (-123.45);