Values are different between TERADATA & MySQL [Excel]

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

Values are different between TERADATA & MySQL [Excel]

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


Wiki

Accepted Solutions
Enthusiast

Re: Values are different between TERADATA & MySQL [Excel]

Got it!!

Log() in MySQL is natural logirthm, whereas in TERADATA Log Base 10.

I used LN() instead of LOG() in TERADATA, which solved my problem.


Wiki
1 ACCEPTED SOLUTION
1 REPLY
Enthusiast

Re: Values are different between TERADATA & MySQL [Excel]

Got it!!

Log() in MySQL is natural logirthm, whereas in TERADATA Log Base 10.

I used LN() instead of LOG() in TERADATA, which solved my problem.


Wiki