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.