Floor function

Syntax

FLOOR …numeric-expr…

Typing

numeric -> numeric

Description

Return the round value just smaller or equal to the operand.

The result has the same type than the operand.

Examples

expression evaluates to
FLOOR 42.7 42
FLOOR(-42.7) -43

See Also

Ceiling function Integer division Rounding Rounding to selected precision