Changing or Overriding the TIME and TIMESTAMP Format Settings - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zsn1556242031050.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

You can change or override the TIME and TIMESTAMP format settings for field mode in the following ways:

  • Change the system default TIME and TIMESTAMP formats in the specification for data formatting (SDF) file.
  • Specify a format in a FORMAT phrase.

    The FORMAT phrase sets the format for a specific TIME or TIMESTAMP column or value. A FORMAT phrase overrides the system format.

The TIME and TIMESTAMP format setting pertains to data in report form, as is the case in BTEQ. The format does not control internal storage representation of data or data returned in record or indicator variable mode.

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