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