I executed the following statement: UPDATE Table1 SET date_adm=date_adm+2 where date_adm='2002-10-30';
the result was...0000-00-00 I´m working with Mysql-max-nt 3.23.39. What´s wrong? best regards, Sil --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php