Intervals
The OLE DB specification does not contain a data type that is equivalent to the Teradata Database INTERVAL types such as:
If a column in a table is defined as an INTERVAL type, then OLE DB Provider for Teradata interprets the data type for this column as DBTYPE_BYTES.
Because OLE DB Provider for Teradata is unable to identify columns of type INTERVAL, the consumer cannot use the interfaces IRowsetChange and IRowsetUpdate to update rowsets that contain INTERVAL columns.
If the consumer attempts to update a row using the SetData, InsertRow, or DeleteRow methods, then Teradata Database returns the following error message:
[Teradata Database]Invalid operation on ANSI Datetime or Interval value