SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Language Elements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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.