16.10 - Example: Using FORMAT to Override Default Format - 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

Another example of overriding the column default and formatting the output:

   SELECT salary (FORMAT '$$$,$$9.99')
   FROM employee
   WHERE empno = 10019 ;

The system returns:

       Salary
       ------
   $28,600.00