---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/round.md
cuppy_section: docs
cuppy_doc: HN04-NKRB
cuppy_doc_uuid: a85480a7-0395-421e-aa36-5c5a26e14e9c
cuppy_permalink: https://cuppy.io/salesforce/d/HN04-NKRB
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/round
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: f423148ca8b88cd89cbea8ac5cd5027facc5ddccd6f47b658a44bc825e4907b6
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> 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`.

*   [TRUNC](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/trunc.html)
*   [CEIL / CEILING](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/ceil.html)
*   [FLOOR](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/floor.html)
*   [Mathematical Functions and Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/math-func.html)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->