Modulo

Modulo operator.

Returns the remainder after division of the left numeric operand by the right numeric operand.

Category: binary

SQL symbol: %

Example

SELECT 1.5 % 1; -- expected: 0.5

Signatures

  • double % integer → double
  • integer % integer → integer

Types

  • Left: double, integer
  • Right: integer
  • Result: double, integer