Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

Approximate Numeric Data Types

Syntax

approx_numeric_data_type ::

REAL

| FLOAT [ (precision) ]

| DOUBLE [ precision ]

Arguments

  • REAL

    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.

  • FLOAT | DOUBLE PRECISION

    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

TOCIndex