SQL & PL/SQL

Hello Everyone,

Below are some queries which behaves differently in case of BINARY_DOUBLE and BINARY_FLOAT data type.

           SELECT ROUND(CAST(28369.524079320112 AS binary_double) ,3) FROM DUAL; --28369.524

           SELECT ROUND(CAST(16.7415 AS binary_double) ,3) FROM DUAL; --16.741

           SELECT ROUND(CAST(28369.524079320112 AS binary_float) ,3) FROM DUAL; --28369.523

           SELECT ROUND(CAST(16.7415 AS binary_float) ,3) FROM DUAL; --16.742

can some please explain to me why this type of behaviour is with these data types.

Thanks,

Vipin Kumar Rai