UPDATE DateTime type field in ExecuteSQL function

I have a database created by MS SQL Server 6.5. I made MFC Application with database view. I call ExecuteSQL function where I want to call SQL command "UPDATE table1 SET column3={^1976-03-12,11:12:13a}". Column3 is DateTime type. I tried a lot of date formats but I always obtain error message "Syntax error".

What is the correct date notation ?


Thanks for help, Rado.

Try this SQL command:

" UPDATE table1 SET column3 = '1976-03-12 11:12:13AM' "


Good luck!


Ly Nguyen