CEILING

Updated 2023-10-20 15:22:47.843000

Syntax

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

Description

Use the scalar function CEILING to calculate a number rounded up, away from 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 CEILING(100.1, 1) would return 101.

Arguments

@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.

@Number

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

Return Type

float

Remarks

The sign of @Number and @Significance must be the same.

The term rounding up always means rounding away from zero.

Examples

SELECT wct.CEILING(100.1, 1);

Here is the result set.

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