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 date ODBC SQL data type is:
SQL_TYPE_DATE
The following table shows the ODBC C data types to which date 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 11 <= BufferLength <= Character byte length BufferLength < 11 |
Data Truncated data Undefined |
10 Length of data in bytes Undefined |
n/a 01004 22003 |
| SQL_C_WCHAR | BufferLength > Character length 11 <= BufferLength <= Character length BufferLength < 11 |
Data Truncated data Undefined |
10 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 | None[a] | Data | 6[c] | n/a |
| SQL_C_TYPE_TIMESTAMP | None[a] | Data[b] | 16[c] | n/a |
[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 time fields of the timestamp structure are set to zero.
[c] This is the size of the corresponding C data type.
When date SQL data is converted to character C data, the resulting string is in the "yyyy-mm-dd" format. This format is not affected by the Windows country/region setting.