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: