Query_Lang-SystemFunctions_Arithmetic_FRACFRAC_AD
Created: 8月 02, 2022 | Updated: 8月 02, 2022
| Applies to version: 4
This document is no longer available beyond version 4. Information can now be found here: FRAC for version 5
Parent page: System Query Functions - Arithmetic Functions
Summary
Returns a (real) number, whose value depends upon the nature of the parameter's numeric value:
- If that numeric value is positive but is not an exact integer, the number returned is the difference between the parameter's numeric value and the largest integer that is smaller in value than the parameter's numeric value.
- If that numeric value is negative but is not an exact integer, the number returned is the difference between the parameter's numeric value and the smallest integer that is larger in value than the parameter's numeric value.
- If the parameter's numeric value is an exact integer, the number returned is 0.
Syntax
FRAC(X : Number / Numeric_String) : Number
Example Usage
FRAC(5.0)
Returns 0.
FRAC(5.33)
Returns 0.33.
FRAC(-5.0)
Returns 0.
FRAC(-5.33)
Returns -0.33.