float Data Type

float data expresses a variable-precision, inexact number.

Detail Info
Size 8 bytes
Min value 2.2250738585072014 × 10-308
Max value 1.7976931348623158 × 10308

Syntax 

int . frac

Details 

Details 

Valid casts 

From float 

You can cast float to:

To float 

You can cast the following types to float:

Examples 

SELECT 1.23::float AS float_v;
 float_v
---------
    1.23