The DATETIME type mapping
Version 2.8 of HCL 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 HCL Informix OLE DB Provider maps to each DATETIME type.
HCL 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
HCL 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
HCL 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