TO_NUMBER

The TO_NUMBER function is deprecated. No warranties are provided to guarantee continued proper functionality. Converts a given string expression into a number.

Use the CAST function for more efficient data-type conversions.

Syntax

TO_NUMBER (expression)

The expression is a column name that returns a string, string literal, or the result of another function.