Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime
Returns the positive remainder after dividend / divisor.
Syntax
pmod(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 type of divisor.
In all other cases a DOUBLE.
If divisor is 0 the function raises a DIVIDE_BY_ZERO error.
Examples
> SELECT pmod(10, 3), mod(10, 3);
1 1
> SELECT pmod(-10, 3), mod(-10, 3);
2 -1
> SELECT pmod(-10, 0);
Error: DIVIDE_BY_ZERO