MOD
MOD ( <dividend>, <divisor> ) <dividend> := <integer-expression> <divisor> := <integer-expression>
Returns the remainder when the first argument (the dividend is divided by the second numeric argument (the divisor). If the divisor is zero, a divide by zero error is raised.
Examples
| Function | Result |
|---|---|
|
MOD(4,2) |
0 |
|
MOD(5,3) |
2 |
|
MOD(-4,3) |
-1 |
|
MOD(5,12) |
5 |
Limitations
The Amazon Kinesis Data Analytics MOD function only supports arguments of scale 0 (integers). This is a departure from the SQL:2008 standard, which supports any numeric argument. Other numeric arguments can be CAST to an integer, of course.
