Teradata ODBC Driver SQL Types

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

ODBC Driver for Teradata is limited to Period SQL database types as listed in the following table.

ODBC SQL Type Identifier Teradata SQL Data Type Definition in ODBC Driver for Teradata
SQL_PERIOD_DATE PERIOD(DATE) An anchored duration of dates
SQL_PERIOD_TIME PERIOD(TIME) or PERIOD(TIME(n)) An anchored duration of times. The precision n is from 0-6, default = 6.
SQL_PERIOD_TIME_WITH_TIME_ZONE PERIOD(TIME WITH TIME ZONE) or PERIOD(TIME(n) WITH TIME ZONE) An anchored duration of times, including time zone. The precision n is from 0-6, default = 6.
SQL_PERIOD_TIMESTAMP PERIOD(TIMESTAMP) or PERIOD(TIMESTAMP(n)) An anchored duration of time stamps. The precision n is from 0-6, default = 6.
SQL_PERIOD_TIMESTAMP_WITH_TIME_ZONE PERIOD(TIMESTAMP WITH TIME ZONE) or PERIOD(TIMESTAMP(n) WITH TIME ZONE) An anchored duration of time stamps, including time zone. The precision n is from 0 to 6, default = 6.
SQL_TD_FIXED_NUMBER NUMBER(p) or NUMBER(p, s) Fixed Number data types are mapped to the standard SQL_DECIMAL data type
SQL_TD_FLOATING_NUMBER NUMBER or NUMBER(*) or NUMBER(*,s) Floating Number data types are mapped to SQL_DOUBLE.
SQL_TD_XML XML XML documents, and also non-well-formed text entities such as fragments of XML documents.

The ODBC SQL type values are defined in the header file tdsql.h in <InstallDir>/include, which defines Teradata-specific attributes for ODBC connection, statement, and descriptor objects.