MDAC 2.5 SDK - ODBC Programmer's Reference
Appendix D: Data Types
The identifier for the timestamp ODBC SQL data type is:
SQL_TYPE_TIMESTAMP
The following table shows the ODBC C data types to which timestamp SQL data may be converted. For an explanation of the columns and terms in the table, see "Converting Data from SQL to C Data Types."
| C type identifier | Test | *TargetValuePtr | *StrLen_or_IndPtr | SQLSTATE |
| SQL_C_CHAR | BufferLength > Character byte length
20 <= BufferLength <= Character byte length BufferLength < 20 |
Data Truncated data[b] Undefined |
Length of data in bytes Length of data in bytes Undefined |
n/a 01004 22003 |
| SQL_C_WCHAR | BufferLength > Character length 20 <= BufferLength <= Character length BufferLength < 20 |
Data Truncated data[b] Undefined |
Length of data in characters
Length of data in characters Undefined |
n/a 01004 22003 |
| SQL_C_BINARY | Byte length of data <= BufferLength
Byte length of data > BufferLength |
Data Undefined |
Length of data in bytes
Undefined |
n/a 22003 |
| SQL_C_TYPE_DATE | Time portion of timestamp is zero[a]
Time portion of timestamp is nonzero[a] |
Data Truncated data[c] |
6[f] 6[f] |
n/a 01S07 |
| SQL_C_TYPE_TIME | Fractional seconds portion of timestamp is zero[a]
Fractional seconds portion of timestamp is nonzero[a] |
Data[d] Truncated data[d], [e] |
6[f] 6[f] |
n/a 01S07 |
| SQL_C_TYPE_TIMESTAMP | Fractional seconds portion of timestamp is not truncated[a]
Fractional seconds portion of timestamp is truncated[a] |
Data[e] Truncated data[e] |
16[f] 16[f] |
n/a 01S07 |
[a] The value of BufferLength is ignored for this conversion. The driver assumes that the size of *TargetValuePtr is the size of the C data type.
[b] The fractional seconds of the timestamp are truncated.
[c] The time portion of the timestamp is truncated.
[d] The date portion of the timestamp is ignored.
[e] The fractional seconds portion of the timestamp is truncated.
[f] This is the size of the corresponding C data type.
When timestamp SQL data is converted to character C data, the resulting string is in the "yyyy-mm-dd hh:mm:ss[.f...]" format, where up to nine digits may be used for fractional seconds. This format is not affected by the Windows® country setting. (Except for the decimal point and fractional seconds, the entire format must be used, regardless of the precision of the timestamp SQL data type.)