Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The INTMOD function returns the remainder of dividing the first integer value by the second.
Syntax
INTMOD(<numeric_expr_1>, <numeric_expr_2>)
Arguments
| Description | |
|---|---|
numeric_expr_1 |
The numerator numeric expression. |
numeric_expr_2 |
The denominator numeric expression. |
Return types
Returns a numeric expression.
Examples
This section contains examples of how to use this query language construct.
Modulo of integer values
In this example, the INTMOD function is used to return the remainder of two numbers.
SELECT VALUE {
mod: INTMOD(12, 5),
positiveResult: INTMOD(12, -5),
negativeResult: INTMOD(-12, -5),
resultZero: INTMOD(15, 5),
modZero: INTMOD(12, 0),
modDecimal: INTMOD(12, 0.2)
}
[
{
"mod": 2,
"positiveResult": 2,
"negativeResult": -2,
"resultZero": 0
}
]