Database Reference
In-Depth Information
Figure 9.6
Some String
Functions.
FLOOR(1.9) = 1
MOD(m, n) . MOD is the modulus or remainder function, which
returns the remainder of the first value divided by the second value ( m
divided by n ). The first value is returned if the second value is zero.
MOD(5,2) = 1
MOD(4,0) = 4
MOD(9,3) = 0
MOD(23,4) = 3
POWER(m, n) . The exponential function raises m to the power of n
(the nth power).
POWER(2,3) = 8 (2 3 = 2 * 2 * 2 = 4 * 2 = 8)
ROUND(n [, places]) . ROUND is a proper mathematical rounding
function as opposed to the CEIL and FLOOR functions. For the
ROUND function, a decimal 5 and over will be rounded up and
below 5 will be rounded down. The third example following is
rounded to two decimal places and the fourth to three decimal places.
 
Search WWH ::




Custom Search