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'.

You can pass a column into the function so that each row of data is processed. For example:

FLOOR(MyColumn)