mod function (Databricks SQL)

Returns the remainder after dividend / divisor.

Syntax

mod(dividend, divisor)

Arguments

  • dividend: An expression that evaluates to a numeric.

  • divisor: An expression that evaluates to a numeric.

Returns

If both dividend and divisor are of DECIMAL, the result matches the divisor’s type. In all other cases, a DOUBLE.

If divisor is 0, the function raises a DIVIDE_BY_ZERO error.

This function is equivalent to the % (percent sign) operator (Databricks SQL).

Examples

> SELECT MOD(2, 1.8);
 0.2

> SELECT MOD(2, 0);
 Error: DIVIDE_BY_ZERO