17.10 - Example: With FORMAT Clause - 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 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.