Example: No FORMAT Clause - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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