16.10 - Example: Without 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

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