The DATETIME type mapping

Version 2.8 of Informix® OLE DB Provider maps DATETIME types to the smallest type that can contain the start and end fields of the DATETIME value. The following lists show how Version 2.8 Informix OLE DB Provider maps to each DATETIME type.

Informix OLE DB Provider DBTYPE_DBDATE is the mapped type for:
  • DATETIME YEAR TO YEAR
  • DATETIME YEAR TO MONTH
  • DATETIME YEAR TO DAY
  • DATETIME MONTH TO MONTH
  • DATETIME MONTH TO DAY
  • DATETIME DAY TO DAY
Informix OLE DB Provider DBTYPE_DBTIME is the mapped type for:
  • DATETIME HOUR TO HOUR
  • DATETIME HOUR TO MINUTE
  • DATETIME HOUR TO SECOND
  • DATETIME MINUTE TO MINUTE
  • DATETIME MINUTE TO SECOND
  • DATETIME SECOND TO SECOND
Informix OLE DB Provider DBTYPE_DBTIMESTAMP is the mapped type for:
  • DATETIME YEAR TO HOUR
  • DATETIME YEAR TO MINUTE
  • DATETIME YEAR TO SECOND
  • DATETIME YEAR TO FRACTION
  • DATETIME MONTH TO HOUR
  • DATETIME MONTH TO MINUTE
  • DATETIME MONTH TO SECOND
  • DATETIME MONTH TO FRACTION
  • DATETIME DAY TO HOUR
  • DATETIME DAY TO MINUTE
  • DATETIME DAY TO SECOND
  • DATETIME DAY TO FRACTION
  • DATETIME HOUR TO FRACTION
  • DATETIME MINUTE TO FRACTION
  • DATETIME SECOND TO FRACTION
  • DATETIME FRACTION TO FRACTION