Name

mod — returns the modulus of its arguments

Synopsis

mod ( dividend integer ,
  divisor integer );
 

Description

mod returns the modulus (i.e. remainder) of the division dividend/divisor. If the divisor is zero the SQL error 22012 "Division by zero" is generated.

mod(35,3)                       -> 2
mod(35,-3)                      -> 2
mod(-35,3)                      -> -2
mod(-35,-3)                     -> -2
mod(3,35)                       -> 3
mod(0,7)                        -> 0
mod(60,3)                       -> 0