Re: ROUND function
From: (wrong string) ørgensen <kjorg_at_msn*DOT*com>
Date: 1998/01/20
Message-ID: <eXWP44dJ9GA.136_at_upnetnews03>#1/1
Date: 1998/01/20
Message-ID: <eXWP44dJ9GA.136_at_upnetnews03>#1/1
Nothing weird about the ROUND() function.
It's the way that SQL*Plus displays the number.
Before you try again, try:
SQL> set numwidth 20
SQL> select round(12345678.23423445, 2) from dual;
and you should end up with:
ROUND(12345678.23423445,2)
12345678.23
PS: SQL*Plus' "set numformat 9999999999990.000000" should do the trick for you too
-- Hope this helps Karl Oracle Certified DBA Anton Eskov wrote in message <885285538.705713_at_master.lek.ru>...Received on Tue Jan 20 1998 - 00:00:00 CET
>Hi
>
>I have noticed some strange behaviour of Round function:
>
>SQL> select round(2.34534543,2) from dual;
>
>ROUND(2.34534543,2)
>-------------------
> 2.35
>
>SQL> select round(123456.2345345, 2) from dual;
>
>ROUND(123456.2345345,2)
>-----------------------
> 123456.23
>
>SQL>
>SQL> select round(12345678.23423445, 2) from dual;
>
>ROUND(12345678.23423445,2)
>--------------------------
> 12345678
>
>It seems that the function leaves no more than 8 digits??? Can anyone
please
>comment?
>
>(Oracle 7.3.3 for NT Server)
>
>SY
>Anton
>
>
>
>