Teradata data types (as reported in DBC.Columns.ColumnType can be cryptic and not always easy to remember. Here's a ready reckoner -
|
Abbreviation
|
Equivalent
English :)
|
|
A1
|
ARRAY
|
|
AN
|
MULTI-DIMENSIONAL
ARRAY
|
|
AT
|
TIME
|
|
BF
|
BYTE
|
|
BO
|
BLOB
|
|
BV
|
VARBYTE
|
|
CF
|
CHARACTER
|
|
CO
|
CLOB
|
|
CV
|
VARCHAR
|
|
D
|
DECIMAL
|
|
DA
|
DATE
|
|
DH
|
INTERVAL
DAY TO HOUR
|
|
DM
|
INTERVAL
DAY TO MINUTE
|
|
DS
|
INTERVAL
DAY TO SECOND
|
|
DY
|
INTERVAL
DAY
|
|
F
|
FLOAT
|
|
HM
|
INTERVAL
HOUR TO MINUTE
|
|
HS
|
INTERVAL
HOUR TO SECOND
|
|
HR
|
INTERVAL
HOUR
|
|
I
|
INTEGER
|
|
I1
|
BYTEINT
|
|
I2
|
SMALLINT
|
|
I8
|
BIGINT
|
|
JN
|
JSON
|
|
MI
|
INTERVAL
MINUTE
|
|
MO
|
INTERVAL
MONTH
|
|
MS
|
INTERVAL
MINUTE TO SECOND
|
|
N
|
NUMBER
|
|
PD
|
PERIOD(DATE)
|
|
PM
|
PERIOD(TIMESTAMP
WITH TIME ZONE)
|
|
PS
|
PERIOD(TIMESTAMP)
|
|
PT
|
PERIOD(TIME)
|
|
PZ
|
PERIOD(TIME
WITH TIME ZONE)
|
|
SC
|
INTERVAL
SECOND
|
|
SZ
|
TIMESTAMP
WITH TIME ZONE
|
|
TS
|
TIMESTAMP
|
|
TZ
|
TIME
WITH TIME ZONE
|
|
UT
|
UDT
Type
|
|
XM
|
XML
|
|
YM
|
INTERVAL
YEAR TO MONTH
|
|
YR
|
INTERVAL
YEAR
|
|
=++
|
TD_ANYTYPE
|
Ken Academy is the premier institute for SAP courses London. Ken offer a practical industry-led approach. Ken has emerged as a destination of choice among the students. We have trained enormous students individual as well as corporates who are looking for excelling and building a career in SAP.
ReplyDeleteMaple Hill Outsourcing services is a specialist outsourcing provider working specifically for Uk businesses of all size. Our team is qualified and highly trained in almost every software used in the accounting world.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteYou can also search the best technology on JanBask Training .It's knowledge hub where they share the information & technology in an easiest way.
ReplyDeleteExcelR Machine Learning Institute In Pune
ReplyDeleteIt is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it! Nisar Technology
ReplyDeleteThere is definately a great deal to know about this subject. I like all of the points you've made. smoking pipes
ReplyDeleteIt is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it! Car Accessories
ReplyDeleteNice knowledge gaining article. This post is really the best on this valuable topic. wheel refurbishment
ReplyDeletevery well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteLogistic Regression explained
Correlation vs Covariance
Simple Linear Regression
data science interview questions
KNN Algorithm
Bag of Words Python
Enjoyed reading the article above , really explains everything in detail,the article is very interesting and effective.Thank you and good luck for the upcoming articles
ReplyDeleteSelenium Training in Chennai
very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteTry SAP BPC Training
DevOps Training in Hyderabad .DevOps is a software engineering practice that aims at unifying software development and software operation. Spend more time on the code that matters and less on the tasks that slow your developers down.
ReplyDeleteDevOps Training in Hyderabad
DevOps Course in Hyderabad
Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
ReplyDeletePower BI Training in Hyderabad
Power BI Training in Ameerpet
This is awesome article. Thanks for sharing.
ReplyDeletedevops online training