TO_NUMBER - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Purpose

Converts string_expr to a NUMBER data type.

Syntax



TD_SYSFNLIB.
Name of the database where the function is located.
string_expr

A character expression. string_expr contains a number in the format specified by format_arg. If the conversion fails, NULL is returned.

format_arg

A character expression.

If this syntax element is not valid, an error is returned.

If this syntax element is NULL, NULL is returned.

NLS_param

A character expression.

NLS_param specifies characters that are returned by number format elements:
  • Decimal character
  • Group separator
  • Local currency symbol
  • Dual currency symbol
  • International currency symbol
Valid values for param are:
  • NUMERIC_CHARACTERS = ' 'dg' '
  • CURRENCY = ' ' text ' '
  • DUAL_CURRENCY = ' ' text ' '
  • ISO_CURRENCY= ' ' text ' '

The characters d and g represent the decimal character and group separator respectively. They must be different single-byte characters. Text must be enclosed in apostrophes. Ten characters are available for the currency symbol.

The SDF (Specification for Data Formatting) file is used to determine any default formatting. If NLS_param is specified, it overrides any defaults specified in the SDF file.

If NLS_param is NULL, NULL is returned.