17.10 - Example: TIMESTAMP Output Format in Field Mode - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following table is a nonexhaustive list of formats for presenting an output timestamp in field mode, where the data is 85/09/12 13:20:53.64+03:00.

FORMAT Phrase Result
FORMAT 'MM/DD/YYBHH:MIBT' 85/09/12 01:20 PM
FORMAT 'MMMBDD,BYYBHH:MI:SS' Sep 12, 85 13:20:53
FORMAT 'E3,BM4BDD,BY4BHH:MI:SSDS(F)' Thu, September 12, 1985 13:20:53.64
FORMAT 'YYYY-MM-DDBHH:MI:SSDS(F)Z' 1985-09-12 13:20:53.64+03:00