Examples | FORMAT Phrase and DateTime Formats | Teradata Vantage - 17.10 - Examples: Querying Using Date Formats - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

Use a statement like the following to display a date in uppercase:

SELECT DATE (FORMAT 'MMMbdd,bYYYY') (CHAR(12), UC);

Using 1985-09-12 for data, this statement returns:

SEP 12, 1985

The following query shows how to specify a date if, for example, the p_date column was specified as FORMAT ' DDBMMMBYYYY ':

SELECT *
FROM sales
WHERE p_date = '30 Mar 1994';

If the p_date column was specified as FORMAT ' YYYY-MM-DD ', the query would be as follows:

SELECT *
FROM sales
WHERE p_date = '1994-03-30';