The MOD function returns an integer value that is argument-1 modulo argument-2.

The function type is integer.

The function result is an integer with as many digits as the shorter of argument-1 and argument-2.


Read syntax diagramSkip visual syntax diagramFUNCTION MOD(argument-1 argument-2)
Must be an integer.
Must be an integer. Must not be zero.

The returned value is argument-1 modulo argument-2. The returned value is defined as:

argument-1 - (argument-2 * FUNCTION INTEGER (argument-1 / argument-2))

The following illustrates the expected results for some values of argument-1 and argument-2.

Argument-1 Argument-2 Return
11 5 1
-11 5 4
11 -5 -4
-11 -5 -1
Related Information