ROUND function in Teradata

ROUND function is used to round the number of decimal places. ROUND function takes two parameters,
one is the number to round and second is the number of decimal it should round to.

You must provide second parameter otherwise it will round the number to 0 decimal.

Syntax is:-

ROUND(NUMERIC_FIELD,[ROUND_NUMBER_TO_DECIMAL]);

Example:-

SELECT ROUND(50.352,2) ROUND_TO;

--> 50.35

SELECT ROUND(50.4082,2) ROUND_TO;

--> 50.41

Note:- Above it have rounded to number to two decimal but since the 0 is second decimal so it will skip the same.

SELECT ROUND(70.5462,3) ROUND_TO;

--> 70.546

SELECT ROUND(3.6564) ROUND_TO;

--> 4

Here are 5 frequently asked questions (FAQs) about round functions in Teradata:-

1. What are round functions in Teradata?

   - Round functions in Teradata are SQL functions used to round numeric values to a specified number of decimal places or to the nearest integer. These functions are useful for formatting and presenting numeric data in a desired manner.

2. Which round functions are available in Teradata?

   - Teradata provides several round functions such as ROUND, ROUNDHALFUP, ROUNDHALFDOWN, ROUNDDOWN, ROUNDUP, TRUNC, and CEIL. Each function has its specific behavior regarding rounding and truncating numeric values.

3. How does the ROUND function work in Teradata?

   - The ROUND function in Teradata rounds a numeric value to a specified number of decimal places. It follows standard rounding rules: if the decimal part is 0.5 or greater, the number is rounded up; otherwise, it is rounded down.

4. What's the difference between ROUND and TRUNC functions in Teradata?

   - The ROUND function in Teradata rounds a numeric value to a specified number of decimal places, following standard rounding rules. On the other hand, the TRUNC function truncates a numeric value towards zero, removing the digits after the specified number of decimal places without rounding.

5. How can I round a numeric value to the nearest integer in Teradata?

   - To round a numeric value to the nearest integer in Teradata, you can use the ROUND function with zero decimal places. For example:

     

     SELECT ROUND(123.45, 0); -- Result: 123

     SELECT ROUND(123.65, 0); -- Result: 124

     

   

These FAQs should provide a good understanding of round functions in Teradata and how they can be used to manipulate numeric values effectively.