MOD function

The MOD numeric function returns the remainder when dividing two numbers.

Syntax

Read syntax diagramSkip visual syntax diagramMOD (dividend,divisor)

MOD returns the remainder when the first parameter is divided by the second parameter. The result is negative only if the first parameter is negative. Parameters must be integers. The function returns an integer. If any parameter is NULL, the result is NULL.

For example:
MOD(7, 3)
returns 1
MOD(-7, 3)
returns -1
MOD(7, -3)
returns 1
MOD(6, 3)
returns 0