XLeratorDB/math Documentation
INT
Updated: 17 August 2010
Use INT to calculate a number rounded down, towards zero, to the nearest integer.
Syntax
SELECT [westclintech].[wct].[INT] (
<@Number, 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.
Return Types
float
Remarks
· The term rounding down always means rounding towards zero
Example
SELECT wct.INT(100.9)
Here is the result set
----------------------
100
(1 row(s) affected)