• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • FLOOR()
  • RAND()
  • ROUND()

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.

Example

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

Return

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

See Also

CEIL(), ROUND()

• < CEIL()
• RAND() >