Teradata DATE Format

Teradata DATE format function converts the default date format as per the user requirements. For ANSI date format, by default Teradata follows DATE format as ‘YYYY-MM-DD’ and for IntegerDate Teradata follows date format as ‘YY/MM/DD’. 

The DATE format function can override the default date format of the Teradata system. Alternatively, your Teradata system administrator can change the default date format when the date form is set to IntegerDate types.

Changing the default DATE format involves changing the value of date elements in a custom specification for the DATE formatting file and using the tdlocaledef utility to convert the information into an internal form usuable by Teradata system.

Teradata DATE format syntax

The syntax of DATE format function in Teradata is as follows.

SELECT date_column FORMAT '<format_type>'
FROM TABLE;

Here,

• FORMAT – The keyword for formatting the date value which should be followed by data column.
• format_type – The reuired format you want to show in the resultset.

There are numerous DATE format available in Teradata. Some of are mentioned below.

Teradata DATE formats Example

Teradata TIME formats Example

Teradata TIMESTAMP formats Example