SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—640322-001
6-37
Numeric Data Types
REAL
specifies a 4-byte approximate numeric column. The column stores 32-bit
floating-point numbers with 23 bits of binary precision and 8 bits of exponent.
The minimum and maximum range is from +/- 1.17549435e-38 through
+/ 3.40282347e+38.
DOUBLE PRECISION
specifies an 8-byte approximate numeric column.
The column stores 64-bit floating-point numbers and designates from 1 through 52
bits of precision.
An IEEE DOUBLE PRECISION data type is stored in 8 bytes with 52 bits of binary
precision and 11 bits of exponent. The minimum and maximum range is from +/-
2.2250738585072014e-308 through +/-1.7976931348623157e+308.