All Forums Database
ankitk 2 posts Joined 10/13
01 Sep 2014
Calculation Precision issue Oracle Vs 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




-- Teradata

SELECT CAST(ROUND(  CAST((( CAST(3.82 AS DECIMAL(18,8))/ CAST(23.88 AS DECIMAL(18,8))) * 23.88 ) / CAST(767 AS DECIMAL(18,5)) AS DECIMAL(18,4)) ,2) AS DECIMAL(18,2))


-- 0.01



Ankit K

You must sign in to leave a comment.