Examples | FORMAT Phrase| Teradata Vantage - Example: Without FORMAT Clause - Teradata Vantage - Analytics Database

If the CREATE TABLE statement defined the format for the Salary column as ‘ZZ9999.99’, the result of the statement:

SELECT SUM(Salary) FROM Employee;

is:

SUM(Salary)
-----------
  851100.00