Round() mvSQL database function in Jitterbit App Builder

Summary

Returns a numeric value, rounded to the specified length or precision.

Syntax

ROUND(<numeric_expression>, <length>)

Parameters

numeric_expression

An expression with a numeric data type

length

The precision to which numeric_expression will be rounded.

Returns

numeric

A numeric type rounded appropriately

Remarks

See https://msdn.microsoft.com/en-us/library/ms175003.aspx for more details about the ROUND function on SQL Server

SQLite implementation only supports lengths >= -6

Examples

Round(7654321,-6)

Returns:

8000000