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.
ReplyDeleteGreat Article
DeleteIEEE Projects for CSE in Big Data
Final Year Project Centers in Chennai
Java Training in Chennai
Java Training in Chennai
Maple 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
ReplyDeleteTruly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work!All note able
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
ReplyDeleteAttend The Machine Learning courses in Bangalore From ExcelR. Practical Machine Learning courses in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Machine Learning courses in Bangalore.
ReplyDeleteMachine Learning courses in Bangalore
There 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
Super site! I am Loving it!! Will return once more, Im taking your food additionally, Thanks. ExcelR Data Science Course In Pune
ReplyDeleteEnjoyed 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
Digital marketing is the component of marketing that utilizes internet and online based digital technologies such as desktop computers, mobile phones and other digital media and platforms to promote products and services
ReplyDeleteDigital Marketing Training in Hyderabad
Digital Marketing Course in Hyderabad
Thanks for Sharing This Article. It was a valuable content. Python is an interpreted, high-level and general-purpose programming language. Python's design philosophy emphasizes code readability with its notable use of significant whitespace. Its language constructs and object-oriented approach aim to help programmers write clear, logical code for small and large-scale projects.
ReplyDeletepython Training in Hyderabad
python Course in Hyderabad
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
AWS Training in Hyderabad .Amazon Web Services is a subsidiary of Amazon providing on-demand cloud computing platforms and APIs to individuals, companies, and governments, on a metered pay-as-you-go basis. The AWS technology is implemented at server farms throughout the world, and maintained by the Amazon subsidiary.
ReplyDeleteAmazon web services Training in Hyderabad
Amazon web services Course in Hyderabad
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
Thanks for posting the best information and the blog is very helpful.data science interview questions and answers
ReplyDeleteInformative blog
ReplyDeleteData Science Course in Pune
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
Nice post power bi training
ReplyDeleteNice post devops online training
ReplyDeleteThis is awesome article. Thanks for sharing.
ReplyDeletedevops online training
I was basically inspecting through the web filtering for certain data and ran over your blog. I am flabbergasted by the data that you have on this blog. It shows how well you welcome this subject. Bookmarked this page, will return for extra. data science course in jaipur
ReplyDeleteExtremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. python course in delhi
ReplyDeleteAmazing Article! 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.If you are Searching for info click on given link
ReplyDeleteData science course in pune
Thank you for this amazing blog, i am very satisfied with this blog. keep sharing this type of content with us
ReplyDeleteapart from this if someone is looking for the best training institute in delhi for any course which is given below,
you should go to High Technologies Solutions training institute
this is the one of the best computer institute in delhi for these course .
Best Training Institute for Python training Course in Delhi, NCR
Best Training Institute for AutoCAD Training Course in Delhi, NCR
Best Training Institute for SAP Training Course in Delhi, NCR
Best Training Institute for SAS Training Course in Delhi, NCR
Best Training Institute for c++ training Course in Delhi, NCR