Example: With FORMAT Clause

Teradata Vantageā„¢ Data Types and Literals

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

The result of the following statement:

SELECT SUM(Salary) (FORMAT '$$99,999.99')
   FROM Employee;

is:

SUM(Salary)
-----------
$851,100.00

FORMAT phrases, by themselves, cannot cause conversion of character to numeric data, or numeric to character data. An error message is returned if a FORMAT phrase implies data conversion.