A scalar numeric function
that returns the largest integer less than or equal to a given numeric expression.
Synopsis
{fn FLOOR(numeric-expression)}
These examples show the effect of
FLOOR.
SELECT DISTINCT {fn Floor(167.45)} AS FloorNum
FROM Sample.Person
SELECT DISTINCT {fn Floor(167.00)} AS FloorNum
FROM Sample.Person
SELECT DISTINCT {fn Floor(-167.45)} AS FloorNum
FROM Sample.Person
SELECT DISTINCT {fn FLOOR(-167.00)} AS FloorNum
FROM Sample.Person