Call Level Interface Guide and Reference

Converting Time C Data to SQL Data

The time C data type is:

SQL_C_TIME

Table 214. Converting Time C Data to SQL Data

fSQLType Test SQLSTATE

SQL_CHAR SQL_VARCHAR

Column length >= 8 00000
Column length < 8 22003
SQL_TIME Data value is a valid time 00000
Data value is not a valid time 22007
SQL_TIMESTAMP ^a Data value is a valid time 00000
Data value is not a valid time 22007

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

Note: a The date component of TIMESTAMP is set to the system date of the machine at which the application is running.

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

[ DB2 List of Books | Search the DB2 Books ]