BINARY_FLOAT, BINARY_DOUBLE and float data type

Hi,

How BINARY_FLOAT,  BINARY_DOUBLE and float data type works.  in the below example I added 123456789.123, i knew limit for binary_float is 9 digit, but how its rounding last digit 89 to 92. what algoritham use  please let me know.

 

CREATE TABLE My_BINARY_FLOAT (Col1 BINARY_FLOAT);

insert into My_BINARY_FLOAT values(123456789.123);

select * from My_BINARY_FLOAT;

 

Result:

Col1

------------

123456792 

 

 Thanks,

Rajesh