![]() |
I am having a problem with Rounding. I am subtracting two dates, then dividing by average months in a year. But Teradata is giving me an integer and is rounding down. For example, if I’m subtracting 9/9/15 from 2/1/16, I get 145 days, which divided by Avg.
30 Mar 2016
| 2 comments
,
|
![]() |
Friends, I have the following problem: I have a final table, where some values are rounded wrongly. There is no transformation of these values. The tables have the same data type, decimal (9.2) and FastExport it converts to the same data type. An example I got was a value of 46.23.
12 Feb 2015
| 2 comments
,
|
![]() |
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
01 Sep 2014
,
|
![]() |
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
01 Sep 2014
| 2 comments
,
|