Version: 10.1

USFormat.DoubleToChar

note

This article is about the DoubleToChar method of the USFormat internal component.

Converts a numeric value of type double to a character string.

Returns the result of the conversion as a string.

Syntax

SELECT USFormat.DoubleToChar(
*double*
,         *number-format-pattern*
)

Both double and number-format-pattern are required. Number-format-pattern must be one of the USoft IO formats for number values.

Example

SELECT USFormat.DoubleToChar(
         '1234.56'
,        '9,999.99'
)

The return value of this statement is the string:

1,234.56

USFormat.DoubleToChar​