Float

FLOAT [(integer)]

This data type defines an IEEE standard 754 floating-point field. Floating-point fields can be defined as single or double (default) precision based on the value of integer. If the value of integer is between 1 and 21, the type is single precision floating-point, which requires 4 bytes of storage. If the value of integer is between 22 and 53 inclusive, the type is double precision floating-point, which requires 8 bytes of storage. If the field is specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.