ToDouble

The ToDouble function converts numeric values and numeric strings to the double data byte.

Syntax

ToDouble(<numeric or numeric string>)

Return Type

Double

Details

The minimum Double value is 4.9E-324 and the maximum Double value is 1.7976931348623157E308.

Examples

select ToDouble(8.8), TypeNameOf(ToDouble(8.8))
from Empty();

todouble_01

select ToDouble('120000.4533'), TypeNameOf(ToDouble('120000.4533'))
from Empty();

todouble_02

Related Functions

ToDecimal