FLOAT

The FLOAT data type is an alias for either a  DOUBLE PRECISION data type, depending on the precision you specify.

Syntax

FLOAT [ (precision) ]

precision

The default precision for FLOAT is 52, which is equivalent to DOUBLE PRECISION.

A precision of 23 or less makes FLOAT equivalent to REAL.

A precision of 24 or greater makes FLOAT equivalent to DOUBLE PRECISION.

If you specify a precision of 0, you get an error. If you specify a negative precision, you get a syntax error.

JDBC Metadata Type (java.sql.Types)

REAL or DOUBLE

Usage Notes

If you are using a precision of 24 or greater, the limits of FLOAT are similar to the limits of DOUBLE.

If you are using a precision of 23 or less, the limits of FLOAT are similar to the limits of REAL.

Data defined with type  double at this time. Note that this does not cause a loss of precision, though the data may require slightly more space.