Hey! This content applies only to previous CARTO products

Please check if it's relevant to your use case. On October 2021 we released a new version of our platform.
You can learn more and read the latest documentation at docs.carto.com

Questions / Working with Data / SQL

How can I round decimal values in Builder?

Learn how to round numeric columns in Builder with SQL.

In order to round a numeric value or column to a certain number of decimal places, it would be necessary to apply a SQL query similar to this one, thus using round PostgreSQL function:

SELECT
  *,
  round(column::numeric, 2) as round_column
FROM
  tablename