C to SQL conversion for date data
You can convert the date C data type, SQL_C_TYPE_DATE, to an SQL data type.
The following table shows information about converting date C data to SQL data.
| fSqlType | Test | SQLSTATE |
|---|---|---|
| SQL_CHAR SQL_VARCHAR | Column length >= 10 | 000001 |
| Column length < 10 | 22003 | |
| SQL_TYPE_DATE | Data value is a valid date | 000001 |
| Data value is not a valid date | 22008 | |
| SQL_TYPE_TIMESTAMP2 | Data value is a valid date | 000001 |
| Data value is not a valid date | 22008 | |
| SQL_TYPE_TIMESTAMP_WITH_TIMEZONE3 | Data value is a valid date | 000001 |
| Data value is not a valid date | 22008 | |
| Notes:
|
||