MSSQL - date and time

Hi, i want to update a datetime-field in a mssql database.

If I update fields directly, I can just use
myTable.myField = DateSys+TimeSys
HModify(myTable)

To speed things up, when updating many records, I want to use HExecuteQuery().
I made a simple update-query and use a parameter for the field I want to update.
myQuery.Param1 = DateSys+TimeSys
HExecuteQeury(myQuery)

This will give me an error!! "Conversion failed when converting datetime from character string".
Do i need pre-format the query-parameter?

I'm using WD12 and OLEDB.

Arie

A safe format string to pass to SQL Server to populate a datetime field is:

'YYYY-MM-DDTHH:MMS'

Note the "T" between the date and time.

Kevin