Teradata Data Types - Using in BI Projects

Teradata JOBS
Currently Teradata supports different data types.

  • BYTEINT ==> Signed whole number ==> -128 to 127

  • CHAR ==> Character String  ==> 1to 64000 bytes. The disadvantage is it pads spaces, when you do not give that much string length

  • VARCHAR ==> Character string ==> Only it occupies space, the string length you have given

  • DATE ==>  DATE type  ==> YYYYMMDD format

  • TIME ==> Time value will be stored ==> HH:MM:SS

  • INTEGER ==>Signed whole number ==>   -2,147,483,648 to 2,147,483,647

  • SMALLINT ==> Signed small whole number ==> -32,768 to 32,767

  • DEC ==> Signed decimal number ==> 18 digits on either side ==> DEC(18,0)-Max and DEC(18,18)-small
There are other data types. Keep reading in my next posts.
Read more
 

Comments

Popular posts from this blog

SQL for Quantile Function in Teradata

3 Uses of SAMPLE function in Teradata

All You Need NULL Value Functions