I'm trying to run below expression in one of my function. Results are different between MySQL, MS Excel Vs TERADATA. Can someone please help me findout where's the mistake.
select (((((-0.0077848940024302926 * SQRT(-2 * LOG(0.015)) + -0.32239645804113648) * SQRT(-2 * LOG(0.015)) - 2.4007582771618381)* SQRT(-2 * LOG(0.015)) - 2.5497325393437338) * SQRT(-2 * LOG(0.015)) + 4.3746641414649678) * SQRT(-2 * LOG(0.015)) + 2.9381639826987831) / ((((0.0077846957090414622 * SQRT(-2 * LOG(0.015)) + 0.32246712907003983) * SQRT(-2 * LOG(0.015)) + 2.445134137142996) * SQRT(-2 * LOG(0.015)) + 3.7544086619074162) * SQRT(-2 * LOG(0.015)) + 1)
MySQL = -2.170090375453823
TERADATA = -0.988750185234164
I need the values to be same as what's coming in MySQL/MS Excel
Solved! Go to Solution.
Copyright © 2004-2015 Teradata Corporation. Your use of this Teradata website is governed by the Privacy Policy and the Terms of Use, including your rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.
The Privacy Policy and Terms of Use for this Teradata website changed effective September 8, 2016.