0 - 6 of 6 tags for precision

Hello,
I am trying to use the LEAST() function to take the minimum of several decimal arguments, but the return value is rounded to the nearest 1. Is there a way around this?
Thanks,
Stephen

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

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

Hi,

We have Teradata 12 on Linux SLES10 - SP1

When i run the command (several times, for comparision and i removed the timezone info from results):

select current_timestamp(6);

2012-02-21 08:52:00.150000

2012-02-21 08:52:29.600000

2012-02-21 08:52:46.260000

2012-02-21 08:54:24.440000

 

Teradata currently supports up to 38 digits in DECIMAL columns. There are several ways to control how many digits you're working with, and they interact in various ways.