Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/round.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

`ROUND`

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Rounds a value to the nearest integer or to a specified number of decimal places.

<dp_or_numeric> / <v>: The double precision or numeric value to round.

<s>: The number of decimal places to round to. When omitted, the value is rounded to the nearest integer.

Returns the rounded value by using the same data type as the input.

Rounding behavior on ties (values exactly halfway between two integers) is unspecified.
A negative value for s rounds to the left of the decimal point.
Non-finite floating-point values (Infinity, NaN) are returned unchanged.

Round a value with no decimal places specified.

Returns 42.

Round a value to two decimal places.

Returns 42.44.

Use a negative number of decimal places to round to tens, hundreds, and so on.

Returns 1200.