Navigation:  »No topics above this level«

FLOOR()

Advantage Concepts

Return to chapter overview

Scalar function to compute the integer floor of a number.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

FLOOR( <nValue> ) à nInteger

Parameters

<nValue>

Floating point value

Return Value

The floor of <nValue>

Remarks

FLOOR returns the largest integer less than or equal to <nValue>. In SQL usage, he return value is of the same data type as the input parameter.  In navigational usage, the result is a double floating point value.

See Also

Math Functions

CEILING()