TeraTeam UK Teradata DBA Definition
Teradata Data Types:
*= Not ANSI Standard
Numeric Data Types
INTEGER
SMALLINT
BYTEINT*
DATE*
REAL
DOUBLE PRECISION
FLOAT [n]
DECIMAL [(n[,m])]
NUMERIC [(n[,m])]
DateTime Data Types
DATE1
TIME [(n)]
TIMESTAMP [(n)]
TIME [(n)] WITH TIME ZONE
TIMESTAMP [(n)] WITH TIME ZONE
INTERVAL
INTERVAL YEAR [(n)]
INTERVAL YEAR [(n)] TO MONTH
INTERVAL MONTH
INTERVAL DAY [(n)]
INTERVAL DAY [(n)] TO HOUR
INTERVAL DAY [(n)] TO MINUTE
INTERVAL DAY [(n)] TO SECOND
INTERVAL HOUR [(n)]
INTERVAL HOUR [(n)] TO MINUTE
INTERVAL HOUR [(n)] TO SECOND
INTERVAL MINUTE [(n)]
INTERVAL MINUTE [(n)] TO
SECOND [(m)]
INTERVAL SECOND [(n,[m])]
Character Data Types
CHAR[(n)]
VARCHAR(n)
CHAR VARYING(n)
LONG VARCHAR *
Byte Data Types
BYTE[(n)] *
VARBYTE(n) *
Graphic Data Types
GRAPHIC[(n)] *
VARGRAPHIC(n) *
LONG VARGRAPHIC *
More Information is available in a Teradata PDF Document here
