FLOAT Function

Purpose

Converts a string or arithmetic value to a floating-point arithmetic value, with a specified precision.

Syntax

FLOAT(x,p)

Parameters

x is a string or arithmetic value, and p is an integer representing precision.

Description

The FLOAT function converts a string or arithmetic value x to a floating-point arithmetic value, with a specified precision p. The resulting floating-point arithmetic value is converted according to the rules for type conversion given in the chapter Data Type Conversions.

Examples

FLOAT(98.614,8)   /* returns 9.8614 E+01 */