Home -> Usenet -> comp.databases.oracle -> ROUND function

ROUND function

From: Anton Eskov <anton_at_msoft.ru>
Date: 1998/01/20
Message-ID: <885285538.705713_at_master.lek.ru>#1/1 







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
Received on Tue Jan 20 1998 - 00:00:00 CET












Original text of this message