Call Level Interface Guide and Reference

Converting Date C Data to SQL Data

The date C data type is:

SQL_C_DATE

Table 213. Converting Date C Data to SQL Data

fSQLType Test SQLSTATE

SQL_CHAR SQL_VARCHAR

Column length >= 10 00000
Column length < 10 22003
SQL_DATE Data value is a valid date 00000
Data value is not a valid date 22007
SQL_TIMESTAMP ^a Data value is a valid date 00000
Data value is not a valid date 22007

Note: SQLSTATE 00000 is not returned by SQLError(), rather it is indicated when the function returns SQL_SUCCESS.

Note: a, the time component of TIMESTAMP is set to zero.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]