SQL Server FLOOR function

FLOOR

Updated: 17 August 2010

Use FLOOR to calculate a number rounded down, towards zero, to the nearest multiple of significance. For example, it you are dealing with a currency for which there are no fractional units, the formula FLOOR(100.9, 1) would return 100.

Syntax

SELECT [westclintech].[wct].[FLOOR] (

<@Number,float,>

,<@Significance,float,>)

Arguments

@Number

is the value to be round down, towards zero. @Number is an expression of type float or of a type that can be implicitly converted to float.

@Significance

is the multiple to which you want to round. @Significance is an expression of type float or of a type that can be implicitly converted to float.