Re: ROUND function

Actually, there is no bug. It's a format matter . try this :

 select round(12345678.23423445, 2) RND NB from dual; RESULT : 12345678 Now change the format of RND NB by typing in : COL RND NB FORMAT 999999999999.99 RE-RUN now the select .
RESULT: 12345678.23 Anton Eskov wrote in message <885285538.705713_at_master.lek.ru>...

    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                    

--