your date format is not correct. It should be activity_date = '2003-9-10 10:00:00'.
-----Original Message----- From: Franck Babin [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: Dummy problem with UPDATE for DATETIME field I have this simple sql statement: UDPATE activity SET activity_date = '9.10.2003 10:00:00', type_no = 1 WHERE DATE_FORMAT(activity_date,'%d.%m.%Y %H:%i') = '09.10.2003 10:00' AND type_no = 1; I'm not able to execute the query. It seems that the <SET activity_date = '9.10.2003 10:00:00'> portion is not valid. <activity_date> is a DATETIME field. Any idea? ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
