|
|
Ispirer SQLWays Database Migration Software
FLOAT, REAL and DOUBLE
FLOAT[(n)]
FLOAT data type is used to store single-precision and double-precision floating-point numbers.
A single-precision floating-point number is a 32-bit approximation of a real number. The number can be zero or can range from -3.402E+38 to -1.175E-37, or from 1.175E-37 to 3.402E+38. The range of n is 1 to 24. IBM DB2 internally represents the single-precision FLOAT data type as the REAL data type.
A double-precision floating-point number is a 64-bit approximation of a real number. The number can be zero or can range from -1.79769E+308 to -2.225E-307, or from 2.225E-307 to 1.79769E+308. The range of n is 25 to 53. IBM DB2 internally represents thedouble-precision FLOAT data type as the DOUBLE [PRECISION] data type.
If n is not specified the default value is 53.
REAL
A single-precision floating-point number.
DOUBLE [PRECISION]
A double-precision floating-point number.
|
|