Teradata Access Module for OLE DB | Functions | Date and Time Data Types - Date and Time Data Types - Access Module

Teradata® Tools and Utilities Access Module Reference - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Access Module
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-12
dita:mapPath
cya1691484517272.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
hjf1479308836950
Product Category
Teradata Tools and Utilities
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 Access Module for OLE DB adds a number to the new column names to maintain unique names for the new columns; for example, ColumnName_DATE_2.