Dear all, How can I change the year of the date field using sql statement?
It means something like: update table1 set year(f1) = '2002' where year(f1) = '2003'; Thanks for anyone's help. Regards, Hakkan Lui --------------------------------------------------------------------- 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