Syntax
approx_numeric_data_type ::
REAL
| FLOAT [ (precision) ]
| DOUBLE [ precision ]
Arguments
Type REAL corresponds to a single precision floating point number equivalent to the C language float type.
It is a 4-byte, IEEE 754 binary floating point number.
Its safe integer range is from −9,999,999 to 9,999,999. Its largest number is ±3.4028234664e+38. Its smallest fraction is ±1.1754943508e-38.
Type FLOAT corresponds to a double precision floating point number equivalent to the C language double type. By default, FLOAT columns have a precision of 8.
It is an 8-byte, IEEE 754 binary floating point number.
Its safe integer range is from −9,007,199,254,740,991 to 9,007,199,254,740,991. Its largest number is ±1.7976931348623158e+308. Its smallest fraction is ±2.2250738585072014e-308.
In V11 and later, DOUBLE can be used as an alias for DOUBLE PRECISION.
Numeric Literals
Literals are a type of expression that specify a constant value (they are also called constants). You can specify literals wherever FairCom DB SQL syntax allows expressions.
A numeric literal is a string of digits that FairCom DB SQL interprets as a decimal number. FairCom DB SQL allows the string to be in a variety of formats, including scientific notation.
Syntax
[+|-]{[0-9][0-9]...}[.[0-9][0-9]...][[E|e][+|-][0-9]{[0-9]}]
Examples
The following are all valid numeric strings:
123
123.456
-123.456
12.34E-04