ROUND

Description

The ROUND function rounds numbers to the nearest integer or decimal. (RedShift SQL Language Reference ROUND function).

Grammar Syntax

ROUND(number [ , integer ] )

This function is fully supported by Snowflake.

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT 28.05 AS score, ROUND(28.05) AS round_score;
SELECT 15.53969483712 AS comission, ROUND(15.53969483712, 2) AS round_comission;

Results

score	round_score
28.05	28

comission	round_comission
15.53969483712	15.54

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT 28.05 AS score, ROUND(28.05) AS round_score;
SELECT 15.53969483712 AS comission, ROUND(15.53969483712, 2) AS round_comission;

Results

score	round_score
28.05	28

comission	round_comission
15.53969483712	15.54

Related EWIs

There are no known issues.