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

--0.000

 

 

-- 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

 

Thanks

Ankit K

You must sign in to leave a comment.