pcsoft.us.windevCopyright 2026, PC SOFT4 Feb 2009 19:19:41 Z3 Feb 2009 22:32:31 ZHi, I've got a query that uses native access to MySQL. One of the fields is defined as a datetime field in the database and of course as a Date in the Analysis. The problem is how to supply the value to the parameter of the query to execute. I've tried QRY_Queue_Put.Param_Last_Run_Time =DateSys() + TimeSys() hExecuteQuery(QRY_Queue_Put) which returns an error: Incorrect datetime value: '20090203105444860' for column 'Last_Run_Time' at row 1 How do you supply a date time value to a parameter of a query that does an update. Thanks Glenn Rathke30WEBDEVen_UShttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working/read.awpmoderateur@pcsoft.fr (Le modérateur)webmaster@pcsoft.fr (Le Webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17785/read.awp4 Feb 2009 19:19:41 ZY don't know how it works with MYSQL but with SQLSERVER with native access the way to handle date fields in the analysis is dife…https://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17785/read.awphttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17785/read.awpQuery to write Date/Time not workingguestpcsoft.us.windevhttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17783/read.awp4 Feb 2009 13:29:48 ZHi Glenn, Look at [url]http://forum.mysnip.de/read.php?27131,20891,20948#msg-20948[/url] Regards, Piethttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17783/read.awphttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17783/read.awpQuery to write Date/Time not workingguestpcsoft.us.windevhttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17782/read.awp4 Feb 2009 11:52:49 ZHi Glenn, you can use datetostring(date,"YYYY-MM-DD") + timetostring(time,"HH:MM:SS:CC") to format this for MySQL ( not tested…https://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17782/read.awphttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17782/read.awpQuery to write Date/Time not workingguestpcsoft.us.windevhttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17776/read.awp4 Feb 2009 08:32:33 ZHi Glenn, Did you subtype the date field in the WD analysis to the correct DateTime type? Cheers,https://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17776/read.awphttps://forum.pcsoft.fr/fr-FR/pcsoft.us.windev/17773-query-write-date-time-not-working-17776/read.awpQuery to write Date/Time not working