• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • CEILING()
  • FLOOR()
  • FORMAT()
  • HEX()
  • OCT()
  • RAND()
  • ROUND()
  • UNHEX()

FLOOR()

Return the value of the evaluated expression rounded down to the nearest integer.

Prototype

integer FLOOR(expression expression)

Parameter

• expression - Expression that should evaluate to an integer or decimal number.

Return

Value of the evaluated expression rounded down to the nearest integer.

Example

SELECT OID, Date, FLOOR(Total) AS RoundedTotal FROM Invoice

Related

CEIL(), ROUND()

• < CEILING()
• FORMAT() >