FLOOR (SQL Server Compact)

Returns the largest integer less than or equal to the given numeric expression.

FLOOR (numeric_expression)


An expression of the exact numeric or approximate numeric data type categories, or of data types that are implicitly convertible to float.

Returns the same type as numeric_expression except for the following expressions.

Specified expression

Return type

tinyint , smallint


real /float


Nonnumeric types that can be implicitly converted to float


The following example applies the FLOOR function to the UnitPrice column of the Order Details table.

SELECT [Order ID], [Unit Price], FLOOR([Unit Price]) AS [Floor Value]
FROM [Order Details]
WHERE ([Unit Price] > 100)
ORDER BY [Unit Price]