16.20 - Using the FORMAT Phrase to Set TIME or TIMESTAMP Formats - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Types and Literals

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference

You can use the FORMAT phrase to set the format for a specific TIME or TIMESTAMP column or value. A FORMAT phrase overrides the TIME or TIMESTAMP system format.

Setting a different TIME or TIMESTAMP 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 TIME or TIMESTAMP literal format.
  • To compare or convert strings to TIME or TIMESTAMP values in the column, strings must match that format.

A FORMAT phrase does not change the export data type of TIME or TIMESTAMP values.

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