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]
