SQL to C: Time stamp
The time stamp HCL Informix® ODBC Driver SQL data type is SQL_TIMESTAMP.
| fCType | Test | rgbValue | pcbValue | SQLSTATE |
|---|---|---|---|---|
| SQL_C_BINARY | Length of data ≤ cbValueMax. | Data | Length of data | N/A |
| Length of data > cbValueMax. | Untouched | Untouched | 22003 | |
| SQL_C_CHAR | cbValueMax > Display size. | Data | Length of data | N/A |
| 20 ≤ cbValueMax ≤ Display size. | Truncated data (HCL Informix ODBC Driver truncates the fractional seconds portion of the time stamp.) |
Length of data | 01004 | |
| cbValueMax < 20. | Untouched | Untouched | 22003 | |
| SQL_C_DATE | Time portion of time stamp is zero. | Data | 6 | N/A |
| Time portion of time stamp is nonzero. (HCL Informix ODBC Driver ignores the value of cbValueMax for this conversion. HCL Informix ODBC Driver uses the size of rgbValue for the size of the C data type.) |
Truncated data (HCL Informix ODBC Driver truncates the time portion of the time stamp.) |
6 (The size of the corresponding C data type is 6.) |
01004 | |
| SQL_C_TIMESTAMP | Fractional seconds portion of time stamp is not truncated. | Data | 16 | N/A |
| Fractional seconds portion of time stamp is truncated. (HCL Informix ODBC Driver ignores the value of cbValueMax for this conversion. HCL Informix ODBC Driver uses the size of rgbValue for the size of the C data type.) |
Truncated data (HCL Informix ODBC Driver truncates the fractional seconds portion of the time stamp.) |
16 (The size of the corresponding C data type is 16.) |
01004 |
When HCL Informix ODBC Driver converts time stamp SQL data to character C data, the resulting string is in the yyyy-mm-dd hh:mm:ss[.f...] format, where up to nine digits can be used for fractional seconds. Except for the decimal point and fractional seconds, the entire format must be used, regardless of the precision of the time stamp SQL data type.