This topic has not yet been rated - Rate this topic

ROUND (SSIS Expression)

Returns a numeric expression that is rounded to the specified length or precision. The length parameter must evaluate to an integer.

Copy


          

ROUND(numeric_expression,length)

numeric_expression: Is an expression of a valid numeric type. For more information, see Integration Services Data Types.
length: Is an integer expression. It is the precision to which numeric_expression is rounded.

The same type as numeric_expression.

The length argument must evaluate to a positive integer or zero.

ROUND returns a null result if the argument is null.

These examples round numeric literals to a length of three. The first return result is 137.1570, the second 137.1580.

Copy

ROUND(137.1574,3)
ROUND(137.1575,3)

Functions (SSIS Expression)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ