TODOUBLE

Syntax

TODOUBLE (expression)

Description

Converts numeric or string data to a Double(64) value.

Arguments

expression

The number or string value to convert. expression can be: — Boolean — Byte — Decimal — Integer (any) — String — Unsigned Integer (any)

Returns

A Double (64) value.

Remarks

To do arithmetic or comparisons between Double and Decimal data types , use TODECIMAL to convert any floating point (that is, Double(32), Double(64), or Floating-point constant) operands. See TODECIMAL for more information.

Trying to convert DateTime or String (1) data to Double results in an error.

Example

If Account.AccountNumber contains the value “123456789”:

TODOUBLE(Account.AccountNumber)

Returns: The same value as a Double data type, which allows it to meet target schema definition and be used in other functions.

Related Topics

Data Conversion