Changing or Overriding the DATE Format Settings

Teradata Vantageā„¢ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

You can change or override the DATE format settings in any of the following ways:

  • Change the DateForm at the system level
  • Set the DateForm at the user or session level
  • Change the system default date format in the SDF
  • Specify a format in a FORMAT phrase

Each of these methods involves consequences that are explained in the following topics and summarized in Hierarchy of Date Formats.