FLOOR Function

Returns the largest integer that is less than or equal to the argument.

Category: Mathematical
Returned data type: Real

Syntax

FLOOR(argument)

Required Argument

argument

specifies a value that has a data type of real; this can be specified as a numeric constant, field name, or expression.

Details

This is also called rounding down.

Example

x = floor(3.5)
// outputs 3
 
x = floor(-3.5)
// outputs -4
 
x = floor(-3)
// outputs -3
 
x = floor(-3*1.5)
// outputs -5