> I have one problem: > Date field in MySql database with value as "2002-31-12". > I want to increment or decrement this date and to put it again in table. > Can someone help me to increment or decrement date with some days?
UPDATE yourtable SET yourcolumn = yourcolumn + INTERVAL 1 DAY WHERE ... http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Date_and_time_functions ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php