pcsoft.us.windevCopyright 2026, PC SOFT29 Dec 2008 15:27:39 Z24 Dec 2008 11:51:42 ZHi, 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. Arie30WEBDEVen_UShttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17045-mssql-date-and-time/read.awpmoderateur@pcsoft.fr (Le modérateur)webmaster@pcsoft.fr (Le Webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17045-mssql-date-and-time-17077/read.awp29 Dec 2008 15:27:39 ZA safe format string to pass to SQL Server to populate a datetime field is: 'YYYY-MM-DDTHH:MM:SS' Note the "T" between the dat…https://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17045-mssql-date-and-time-17077/read.awphttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17045-mssql-date-and-time-17077/read.awpMSSQL - date and time