SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—523725-004
6-35
Numeric Data Types
There is no default. You must specify either 9(integer) or V9 (scale).
FLOAT [( precision )]
specifies an approximate numeric column. The column stores floating-point
numbers and designates from 1 through 52 bits of precision. The range is from
+/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308 stored in 8
bytes.
An IEEE FLOAT precision data type is stored as an IEEE DOUBLE, that is, in 8
bytes, with the specified precision.
The default precision is 52.
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.