try_mod function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 15.3 and later

Returns the remainder after dividend / divisor or NULL if`divisor` is 0.

Syntax 

try_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 returns NULL. To raise DIVIDE_BY_ZERO error instead use the mod() function.

Examples 

> SELECT try_mod(2, 1.8);
 0.2

> SELECT try_mod(2, 0);
 NULL