This is an old revision of the document!
Returns “x modulus y”. This is the integral remainder of x divided by y.
This function returns an INTEGER datatype.
MOD( integral_expression, divisor_integral_expression ) integral_expression % divisor_integral_expression
Required. Any expression that returns a integer-class datatype. This value will be divided by the divisor_integral_expression.
Required. Any expression that returns a integer-class datatype. This value will be divided into the integral_expression.
> select population, mod(population, 100) from country_census; POPULATION MOD(COUNTRY_CENSUS.POP ---------------------- ---------------------- 28846761 61 30007094 94 248709873 73 285230516 16
> select population, population % 100 from country_census; POPULATION POPULATION % 100 ---------------------- ---------------------- 28846761 61 30007094 94 248709873 73 285230516 16