Data Type Conversion

Values of one type can sometimes be converted to a different type according to the following table:

Conversion

Input Type

Output Type

Result

Convert_ToBool(x)

Numeric

Boolean

True if x != 0; false otherwise

Convert_ToBool(x)

Boolean

Boolean

x

Convert_ToDouble(x)

Numeric

64 bit float

The closest number to x representable as a 64 bit floating point number

Convert_ToDouble(x)

Boolean

64 bit float

1 if x is true; 0 otherwise