ROUNDDOWN

Returns a number rounded down to the specified precision (number of decimal places).

Usage examples 

  • ROUNDDOWN(1.6)

  • ROUNDDOWN(43.56, 1)

  • ROUNDDOWN(tableA.fieldB)

Syntax 

ROUNDDOWN ( value, [ places ] )

  • value - Any numeric expression.

  • places - Any numeric expression for the number of decimal places. 0 by default.

Returns 

number - The number rounded down.

Functions reference