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