Round function

From: Bala <kmbase_at_rediffmail.com>
Date: 14 Mar 2003 23:07:16 -0800
Message-ID: <f58d1e2f.0303142307.1bcfb0fd@posting.google.com>

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*7,2)

                     1159.6

2.
SQL> select ROUND(2319.21*7/14,2) from dual;

ROUND(2319.21*7/14,2)

1159.61

regards,
Bala Received on Sat Mar 15 2003 - 01:07:16 CST