16.10 - Using the FORMAT Phrase to Set DATE Formats - Teradata Database

Teradata Database SQL Data Types and Literals

Teradata Database
June 2017
Programming Reference

You can use the FORMAT phrase to set the format for a specific DATE column or DATE value. A FORMAT phrase overrides the DATE format of the system, user, and session.

Setting a different DATE format for a column with the FORMAT phrase has the same consequences as with any other method:

  • Data entry for that column must be in the new format or the ANSI DATE literal format.
  • To compare or convert strings to DATE values in the column, the strings must match that format.

A FORMAT phrase does not change the export data type of DATE values.

For details about using the FORMAT phrase, see FORMAT Phrase and DateTime Formats or FORMAT Phrase, DateTime Formats, and Japanese Character Sets.