Date Column Format Restriction - OLE DB Provider for Teradata

Date Column Format Restriction

If the Dt column shown above has a format other than ‘YYYY-MM-DD’

for example, ‘YY-MM-DD’

and the consumer uses the following SELECT statement that does not have the format clause:

   SELECT Ts, Ti, Dt FromTeradata1.DateTime_Test

and the consumer calls either:

IColumnsInfo::GetColumnsInfo

ColumnsRowset::GetColumnsRowset

then OLE DB Provider for Teradata reports that this column is of type DBTYPE_STR.

Tables that contain date columns with other date formats cannot be updated using IRowsetChange or IRowsetUpdate. If the consumer uses any method of either interface, the call returns the DB_E_ERRORSOCCURRED error code and OLE DB Provider for Teradata presents the following error message:

[OLE DB Provider for Teradata]Multiple-step OLE DB operation generated errors. Check each OLE DB status value. No work was done.