Converts a value to a DOUBLE type.

Syntax

DOUBLE ( convExpression )

Arguments

  • convExpression: A value to convert to DOUBLE. convExpression can evaluate to a number or character string of type CHAR or VARCHAR that is a numeric constant.

Returns

  • When convExpression is an integer value, returns the number as a DOUBLE.

  • When convExpression is a character value, returns the number represented by the numeric constant.

  • Returns NULL if convExpression is NULL.

Examples

VALUES DOUBLE(524);
-- Returns
524.00