Hi,
I'm attempting to insert date/time values into an Oracle database, and am having trouble with the syntax of the command. I'm formatting a BSTR within C++ that is going to hold my Insert command. The command looks like this:

_bstr_t strSQLInsert("INSERT INTO Table VALUES");
strSQLInsert("(");
strSQLInsert += (pTrainRec->InsertDate);
strSQLInsert += (",");
etc. etc.

The InsertDate field is a COM DATE (type double) field, and I get an error when I compile saying it cant convert a double to bstr (or something like that). Does anyone know how I can do this to place the date into the string, which I will use in my Execute statement on my connection?
Thanks for your help... Rob