REAL Data Type

The REAL data type represents floating point numeric data.
Floating point data is approximate; not all values in the data type range can be precisely represented.

Value range:

REAL values are represented as signed 64-bit (8-byte) floating point numbers, with values ranging from ±5.0×10^-324 through ±1.7×10³⁰⁸, with at least 15 digits of precision.

Conversion Functions:

Other data types to REAL data type:

• TO_REAL

REAL data type to other data types:

• TO_INT
• TO_STRING
• TO_TIMESTAMP

See also:

© 2004 Microsoft Corporation. All rights reserved.