Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
MOD(a,b)
Engine OK Alternative
mysql yes a % b
oracle yes
postgres yes a % b
sqlserver no a % b

MOD

MOD(a,b) returns the remainder when a is divied by b

If you use MOD(a, 2) you get 0 for even numbers and 1 for odd numbers.

If you use MOD(a, 10) you get the last digit of the number a. 

MOD(27,2) ->  1
MOD(27,10) ->  7
In this example you get the final digit year of the games.

Results
See also: