Post reply

Precision problem in Float DataType

  • March 14, 2008 at 1:00 am

    #120511

    When i update a 'float' value, the last digit in the decimal places is getting modified.

    example,

    update table_name set column_name = 9.2,results in 9.19999999.similarly,

    9.2 ===> 9.199999999

    4.56878 ===> 4.5677999999

    4.873 ===>4.8730000003

    could any help me in solving this problem.

  • March 14, 2008 at 8:35 am

    #789662

    A float datatype is not a precise datatype; give a look at this datatype in books online. If precise decimal positions are needed you might want to consider either the NUMERIC or DECIMAL datatype.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply