Components of Timestamp and Format available in Teradata

In Teradata, there are various components which make timestamp value in a column. This includes Date part: Year, Month and Day and Time part which includes hour, minutes and seconds. Let us see below all the various formats available for these components:

#TypeFormatValueDescription
1YearYY142 digits of century
2YearYYYY2014complete year
3YearY42014complete year
4MonthMM112 digit month
5MonthMMMNovshort form of month
6MonthMMMMNovemberfull name of month
7DayDD122 digit date
8DayDDD316day of the year
9HourHH02Hour
10MinuteMI59Minute
11SecondSS07Second
12Time PeriodTAMAM or PM
13BlankBSPACESpecify Space

You can use combination of above mentioned formats to show your date, time or timestamp values.

Leave a Reply

Your email address will not be published. Required fields are marked *