ROUNDDOWN(number, num_digits)

The ROUNDDOWN function rounds a number down, that is towards 0. num_digits is a positive or negative integer which specifies the number of digits to which you want to round down. num_digit set to a positive integer will round down to the right of the decimal point (the fractional part); set to a negative integer will round down to the left of the decimal point (the whole number part).

For example:

ROUNDDOWN(2.8234, 1)  returns 2.8

ROUNDDOWN(2.8234, 0)  returns 2

ROUNDDOWN(2678, -2)  returns 2600

See also:

Other mathematical functions