Last updated
Last updated
BINARY_FLOAT
is a 32-bit, single-precision floating-point number data type. EachBINARY_FLOAT
value requires 4 bytes. In aBINARY_FLOAT
column, floating-point numbers have binary precision. The binary floating-point numbers support the special values infinity andNaN
(not a number). ()
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
Please, consider the following table and its inserts for the example below:
Since theBINARY_FLOAT
data type is not supported by Snowflake it is being converted to FLOAT.
The BINARY_FLOAT data type is converted to FLOAT since it is not supported by Snowflake.
No related EWIs.