Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The identifier for the timestamp ODBC C data type is:
SQL_C_TYPE_TIMESTAMP
The following table shows the ODBC SQL data types to which timestamp C data may be converted. For an explanation of the columns and terms in the table, see Converting Data from C to SQL Data Types.
| SQL type identifier | Test | SQLSTATE |
|---|---|---|
| SQL_CHAR SQL_VARCHAR SQL_LONGVARCHAR |
Column byte length >= Character byte length 19 <= Column byte length < Character byte length Column byte length < 19 Data value is not a valid timestamp |
n/a 22001 22001 22008 |
| SQL_WCHAR SQL_WVARCHAR SQL_WLONGVARCHAR |
Column character length >= Character length of data 19 <= Column character length < Character length of data Column character length < 19 Data value is not a valid timestamp |
n/a 22001 22001 22008 |
| SQL_TYPE_DATE | Time fields are zero Time fields are nonzero Data value does not contain a valid date |
n/a 22008 22007 |
| SQL_TYPE_TIME | Fractional seconds fields are zero[a] Fractional seconds fields are nonzero[a] Data value does not contain a valid time |
n/a 22008 22007 |
| SQL_TYPE_TIMESTAMP | Fractional seconds fields are not truncated Fractional seconds fields are truncated Data value is not a valid timestamp |
n/a 22008 22007 |
[a] The date fields of the timestamp structure are ignored.
For information about what values are valid in a SQL_C_TIMESTAMP structure, see C Data Types, earlier in this appendix.
When timestamp C data is converted to character SQL data, the resulting character data is in the "yyyy-mm-dd hh:mm:ss[.f...]" format.
The driver ignores the length/indicator value when converting data from the timestamp C data type and assumes that the size of the data buffer is the size of the timestamp C data type. The length/indicator value is passed in the StrLen_or_Ind argument in SQLPutData and in the buffer specified with the StrLen_or_IndPtr argument in SQLBindParameter. The data buffer is specified with the DataPtr argument in SQLPutData and the ParameterValuePtr argument in SQLBindParameter.