Availability of Period Data Types

ODBC Driver for Teradata® User Guide

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

Use of Period data types in the ODBC Driver follows the database; that is, the types are available if the database supports them and are not available if the database does not support them.

It is required that the ODBC Driver time format (see the DateTimeFormat=[A|I]A A description in Teradata DSN Options) is set to ANSI when using Periods. The Date format can be Integer or ANSI. The Timestamp format is always ANSI.