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.