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.

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

01-26-2017
04:01 AM

01-26-2017
04:01 AM

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

Solved! Go to Solution.

Labels:

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

01-26-2017
11:01 PM

1 ACCEPTED SOLUTION

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

01-26-2017
11:01 PM

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.