Type: Function
Function: ROUNDDOWN
Syntax: ROUNDDOWN(number, [precision=0])
Description: Rounds a number to a certain number of decimal places (optional, 0 by default), always rounding down to the next valid increment.
Sample usage:
ROUNDDOWN(10.7)returns10ROUNDDOWN(10.436, 2)returns10.43ROUNDDOWN(AVG(lines_changed))returns the average value for thelines_changedfield value, rounded down to the nearest integer.ROUNDDOWN(AVG(closed_at-created_at)/HOUR(),1)returns the average elapsed time in hours between the creation and the closure of a record, rounded down to the nearest float with one decimal place.