Using Data Types and Literals
Teradata Vantage™ - Data Types and Literals describes the data types and data literals supported by Analytics Database. This document is primarily for application programmers.
Why Would I Use this Content?
Use this content if you want to do the following:
- Specify a data type and data type attributes in SQL data definition phrases.
- Specify a format for a data type. For example, you can specify the format for how dates are displayed.
- Convert or cast from one data type to another.
This document also provides information about compressing data values in table columns and specifying default values for fields.
How Do I Use this Content?
See the information about the data type or data literal you are interested in and how it can be used.
How Do I Get Started?
- Learn how to declare data types in data definition phrases. See SQL Data Definition.
- Look through the list of data types and data literals to get familiar with the types and literals that are available.
- Learn about the default data formats and how to change them. See Data Type Formats and Format Phrases.
- Learn how you can convert data from one type to another. See Data Type Conversions and Data Type Conversion Functions.
References to Other Relevant Content
The following provides information about additional data types supported by Analytics Database:
- Teradata Vantage™ - DATASET Data Type, B035-1198
- Teradata Vantage™ - Geospatial Data Types, B035-1181
- Teradata Vantage™ - JSON Data Type, B035-1150
- Teradata Vantage™ - XML Data Type, B035-1140