Call Level Interface Guide and Reference

Converting Date SQL Data to C Data

The date SQL data type is:

SQL_DATE

Table 205. Converting Date SQL Data to C Data

fCType Test rgbValue pcbValue SQLSTATE
SQL_C_CHAR cbValueMax >= 11 Data 10 00000
cbValueMax < 11 Untouched 10 22003
SQL_C_DATE None ^a Data 6 ^b 00000
SQL_C_TIMESTAMP None ^a Data ^c 16 ^b 00000

Note:

^a
The value of cbValueMax is ignored for this conversion. The driver assumes that the size of rgbValue is the size of the C data type.
^b
This is the size of the corresponding C data type.
^c
The time fields of the TIMESTAMP_STRUCT structure are set to zero.

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

When the date SQL data type is converted to the character C data type, the resulting string is in the "yyyy-mm-dd" format.

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

[ DB2 List of Books | Search the DB2 Books ]