FLOOR
Returns a number rounded down to a multiple of another number.
Usage examples
-
FLOOR(3.3) -
FLOOR(3.34, 1) -
FLOOR(tableA.fieldB)
Syntax
FLOOR ( value, [ floor ] )
-
value- Any numeric expression. -
floor- The number to whose multiples value will be rounded. Factor may not be equal to 0.
Returns
number - The number rounded down to the multiple of another number.