I am working on sybase 11.9.2. I want to insert a value 2.56789 which is stored in a numeric(11,5) datatype column in table mst, to a column which is float in table xyz.
When I perform the insert, the value changes to 2.5678899999999998.
My requirement is to insert the exact value 2.56789 in xyz table. I don't want to change the column datatype in table xyz.