Date, Time, and Timestamp
OLE DB Provider for Teradata uses the ANSI representation of the Date, Time, and Timestamp. Therefore, if a consumer submits the following Data Definition Language (DDL) statement:
CREATE TABLE Teradata1.DateTime_Test (
Ts TIMESTAMP,
Ti TIME,
Dt DATE
PRIMARY INDEX (Ts));
to Teradata Database through OLE DB Provider for Teradata, the table has the following definitions in Teradata Database:
CREATE SET TABLE Teradata1.DateTime_Test ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL
(
Ts TIMESTAMP(6),
Ti TIME(6),
Dt DATE FORMAT 'YYYY-MM-DD')
PRIMARY INDEX ( Ts ));