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

Great Formatting Example for Day, Month, and Year

images

 

 

 

All of these FORMAT requests work wonderfully if the client software is BTEQ or the Nexus Query Chameleon, but SQL Assistant has problems with formatting.

From

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

Note

Teradata Formatting of dates (Day, Month, and Year)