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.
Return Types
float
Remarks
· The sign of @Number and @Significance must be the same
· The term rounding down always means rounding towards zero
Example
SELECT wct.FLOOR(100.9, 1)
Here is the result set
----------------------
100
(1 row(s) affected)