I am having a problem with Rounding.  I am subtracting two dates, then dividing by average months in a year.  But Teradata is giving me an integer and is rounding down.  For example, if I’m subtracting 9/9/15 from 2/1/16, I get 145 days, which divided by Avg.

Friends, I have the following problem: I have a final table, where some values are rounded wrongly. There is no transformation of these values. The tables have the same data type, decimal (9.2) and FastExport it converts to the same data type. An example I got was a value of 46.23.

Hi Team 

While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.

-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual

--0.000

-- Teradata

Hi Team 

While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.

-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual

--0.000

-- Teradata