pmod
function
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
Related functions
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for