InterSystems SQL Reference
MOD


A scalar numeric function that returns the modulus (remainder) of a number divided by another.
Synopsis
{fn MOD(dividend,divisor)}
MOD returns the mathematical remainder (modulus) from the dividend by the divisor. It returns a negative or zero result for a division involving a negative divisor.
MOD returns NULL if passed a NULL value for either argument.
MOD can only be used as an ODBC scalar function (with the curly brace syntax).
The following example shows the remainder returned by
MOD.
SELECT {fn MOD(5,3)} AS Remainder
The following example shows the remainder returned by
MOD with a negative dividend.
SELECT {fn MOD(5,3)} AS Remainder
The following example shows the remainder returned by
MOD with a negative divisor.
SELECT {fn MOD(5,3)} AS Remainder
Content Date/Time: 20190222 00:52:40