TO_BINARY_FLOAT Function in Oracle SQL – PLSQL

The TO_BINARY_FLOAT function in Oracle SQL / PLSQL is used to convert a numeric value into TO_BINARY_FLOAT.

Syntax for the TO_BINARY_FLOAT function in Oracle SQL / PLSQL is:

SELECT TO_BINARY_FLOAT(number)
FROM table_name;

Let’s take an example for understanding:

Suppose we want to convert a number “2345.67” into TO_BINARY_FLOAT.

SELECT TO_BINARY_FLOAT(2345.67)
FROM dual;

The output of the above statement will be:

TO_BINARY_FLOAT(2345.67)
2346E+003

Tagged , , , , , , , , , , , . Bookmark the permalink.