17.10 - Example: Converting a numeric_expr to a Character String - Advanced SQL Engine

17.10 - Example: Converting a numeric_expr to a Character String - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Release Date

July 2021

Content Type

Programming Reference

Publication ID

B035-1143-171K

Language

English (United States)

The following query:

SELECT TO_CHAR(50000, '$99,999.99');

returns '$50,000.00'.