Example: Converting string_expr to a NUMBER Data Type - Teradata Vantage

Teradata® VantageCloud Lake

Deployment: VantageCloud
Edition: Lake
Product: Teradata Vantage
Published: January 2023
ft:locale: en-US
ft:lastEdition: 2024-12-11
dita:mapPath: phg1621910019905.ditamap
dita:ditavalPath: pny1626732985837.ditaval
dita:id: phg1621910019905

The following query returns the result 1789.96:

SELECT TO_NUMBER ('1789.96', '9999.99');