mvSQL Database Function - ROUND()¶

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