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