FLOOR function [Numeric]

FLOOR( numeric-expression )

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).

DOUBLE

This function converts its arguments to DOUBLE, and performs the computation in double-precision floating-point arithmetic.

SQL/2008 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);