floor()

Scalar. Rounds a number down.

Syntax

floor ( value )

Parameters

value

A float or a money type.

Usage

Rounds a given number down to the nearest whole number. The function takes a float or a money type, and the function returns the same datatype as its argument.

Example

floor (100.20) returns 100.0.

floor ( 1.56) returns 1.0.