PMOD

Categories: Math

PMOD

Returns the positive remainder after dividend / divisor. Returns an error if the divisor is 0.

Syntax

PMOD(dividend NUMERIC, divisor NUMERIC) → NUMERIC

• dividend: Dividend value.
• divisor: Divisor value.

Examples

PMOD example

SELECT pmod(10, 3)
-- 1

PMOD example

SELECT pmod(-10, 3)
-- 2