SQL Server INT Function

Updated 2023-10-20 15:25:51.500000

Description

Use the scalar function 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 Type

float

Remarks

The term rounding down always means rounding towards zero.

Examples

SELECT wct.INT(100.9);

Here is the result set.