FLOOR function [Numeric]

Returns the largest integer not greater than the given number.

FLOOR( numeric-expression )

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

Discuter à propos de cette page dans DocCommentXchange.