Work Around - OLE DB Provider for Teradata

Work Around

If the purpose is to update a table, the consumer is responsible for either:

Generating the proper DML statement

Modifying the SELECT statement that created the rowset

Example:

SELECT Ts, Ti, Dt (FORMAT ‘YYYY-MM-DD’) FROM Teradata1.DateTImeTest

For more information on Teradata Date, Time and Timestamps, refer to SQL Data Types and Literals.