15.10 - Date and Time Data Types - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
15.10
category
Programming Reference
featnum
B035-2425-035K

Date and Time Data Types

Two columns are synthesized as follows:

  • The date portion can be copied to a DATE, and the column name is shown as ColumnName_DATE.
  • The time portion can be copied to a TIME, and the column name is shown as ColumnName_TIME.
  • A number can be appended to the new column names as needed to create unique names. For example, if ColumnName_DATE already exists in the table, ColumnName_DATE_2 can be used as the new column name. You can copy the date and time to a TIMESTAMP data type.

    If the data source already contains a column named ColumnName_DATE or ColumnName_TIME, the Teradata OLE DB Access Module adds a number to the new column names to maintain unique names for the new columns; for example, ColumnName_DATE_2.