16.10 - Example: With FORMAT Clause - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

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.