Re: ROUND Function

> Hi all,
> I execute the following two sql statement for ROUND
> function. It gives me two different result. The expected result is of
> No 2 statement output. what might be the problem, is it with
> round function or with the expression.
>
> 1.
> SQL> select ROUND(2319.21/14*7,2) from dual;
>
> ROUND(2319.21/14.00*7.00,2)
> ---------------------------
> 1159.6
>
> 2.
> SQL> select ROUND(2319.21*7/14,2) from dual;
>
> ROUND(2319.21*7/14,2)
> ---------------------
> 1159.61
 

select to_char(round(2319.21/14*7,2),'999990.00') from dual;

select to_char(round(2319.21*7/14,2),'999990.00') from dual;

hth

Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html