Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

TO_NUMBER

TO_NUMBER converts a string to a numeric (decimal) value.

Syntax

Copy
to_number(string, format)

Arguments

string

String to be converted. The format must be a literal value.

format

The second argument is a format string that indicates how the character string should be parsed to create the numeric value. For example, the format '99D999' specifies that the string to be converted consists of five digits with the decimal point in the third position. For example, to_number('12.345','99D999') returns 12.345 as a numeric value. For a list of valid formats, see Numeric Format Strings.

Return Type

TO_NUMBER returns a DECIMAL number.

Examples

The following example converts the string 12,454.8- to a number:

Copy
select to_number('12,454.8-', '99G999D9S'); to_number ----------- -12454.8 (1 row)