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.

The following statement returns a Floor value of 123:

SELECT FLOOR (123);

The following statement returns a Floor value of 123:

SELECT FLOOR (123.45);

The following statement returns a Floor value of -124:

SELECT FLOOR (-123.45);