FLOOR function

Synopsis

This function returns the greatest whole number less than or equal to the specified number. Essentially, this function rounds the specified number downwards to the closest whole number.

Variations

FLOOR(Number)

Returns the largest whole number less than or equal to the specified number.

Details | Examples | Details and examples

Parameters

Number

Specifies the number to round downwards.

Supported types: Numeric.

Returns

Returned types: Numeric.

Examples

1.	The following example returns 4. FLOOR(4.3)
2.	The following example also returns 4. FLOOR(4)