BINARY_FLOAT

circle-info

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentationarrow-up-right

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected]envelope.

Thank you for your understanding.

Description

BINARY_FLOAT is a 32-bit, single-precision floating-point number data type. EachBINARY_FLOATvalue requires 4 bytes. In a BINARY_FLOATcolumn, floating-point numbers have binary precision. The binary floating-point numbers support the special values infinity and NaN (not a number). (Oracle Language Reference Binary_Float data typearrow-up-right)

It is possible to specify floating-point numbers within the next limits:

  • Maximum positive finite value = 3.40282E+38F

  • Minimum positive finite value = 1.17549E-38F

Sample Source Patterns

Please, consider the following table and its inserts for the example below:

Binary Float in Create Table

Oracle

Snowflake

circle-info

'NaN' means Not a Number, this value is allowed by theBINARY_FLOAT data type in Oracle and by theFLOATdata type in Snowflake.

BINARY_FLOAT -> FLOAT

Since theBINARY_FLOATdata type is not supported by Snowflake it is being converted to FLOAT.

Oracle

Snowflake

Known Issues

1. The BINARY_FLOAT data type is not supported by Snowflake

The BINARY_FLOAT data type is converted to FLOAT since it is not supported by Snowflake.

No related EWIs.

Last updated