Example: Converting Salaries - 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

Based on the following description of Salary, data is converted as illustrated in the following table (Δ = pad character):

Salary (DECIMAL(8,2), FORMAT '$$$,$$9.99')
Data Conversion Result
20000.00 Salary (CHAR(10)) '$20,000.00'
9000.00 Salary (CHAR(10)) 'Δ $9,000.00'
20000.00 Salary (FORMAT'9(5)') (CHAR (5)) '20000'
9000.00 CAST (Salary AS CHAR(10)) '$9,000.00Δ '

The resultant character string is either extended with pad characters or truncated to conform to the given character description.