FLOOR

Calculates the floor of a number. Returns the nearest round number less than or equal to the double/decimal.

Syntax

double? FLOOR(double? value)
decimal? FLOOR(decimal? value)

Example

FLOOR(28.9)

Returns '28'.

or

FLOOR(213)

Returns '213'.