O'Reilly logo
  • Darryl Milligan thinks this is interesting:

A Trick to get SQL Assistant to Format Data

images

 

 

 

If a tool uses the ODBC, the FORMAT in the SELECT is ignored and the data comes back as data, not as a formatted field. This is especially noticeable with numeric data and dates.

From

Cover of Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition

Note

Teradata Formatting in SQL Assistant