16.20 - Changing or Overriding the DATE Format Settings - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Types and Literals

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.