INT

Updated 2023-10-20 15:25:51.500000

Syntax

SELECT [westclintech].[wct].[INT] (
   <@Number, float,>)

Description

Use the scalar function INT to calculate a number rounded down, towards zero, to the nearest integer.

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.

{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"100"}]}