Availability of Period Data Types - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use of Period data types in ODBC Driver for Teradata 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 for Teradata 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.