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

A Trick to get SQL Assistant to Format Data





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.


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


Teradata Formatting in SQL Assistant