Date variable usage in CLI/ODBC

RANJAN

Date variable usage in CLI/ODBC
Hi list

For the following ODBC(CLI) code

rc=SQLBindCol(StmtHandle,1,SQL_C_DATE,(SQLPOINTER)
Last_Updt_Dt,sizeof(Last_Updt_Dt), NULL);

SQL_C_DATE represents the C data type of the variable identified as Column 1
in the SQL statement pointed to by StmtHandle . The column is of DATE type
in DB2.
What should be the data type of Last_Updt_Dt whcih is the c / cpp program
variable being bound to Column 1 so that I receive the date as yyyy-mm-dd ;
the default DB2 date format.

sqlchar[10] or sqlchar[11] or something else and why?


thanks
ranjan