Name

floor — Rounds a number down to the next nearest mathematical integer value.

Syntax

floor(number)
                

The FLOOR function has the following arguments:

number

The number or integer of which you want the floor value

Description

The floor function returns the largest (closest to positive infinity) double value that is less than or equal to the argument and is equal to a mathematical integer. The function will return a double precision number.

Examples

Formula

Description

Result

floor(0.9)

Round down 0.9 to the nearest integer

0.0

floor(-5.6)Round down -5.6 to the nearest integer-6.0
floor(10.0)Round down 10.o to the closest integer10.0