I am trying to bind a date time string to a SQL statement and then have it execute, but its giving me probs with the way


SQLBindParameter(hStmtsql,
3,
SQL_PARAM_INPUT,
SQL_C_CHAR,
SQL_TIMESTAMP,
0,
0,
purchases[i]->dateandtime,
sizeof(purchases[i]->dateandtime),
0);

Except it dosen't like the way i'm doing it, does anyone have an example of how to do this, the attribute type is a date time, i just need to be able to insert properly!


Hope someone can help


Andy