Thanks, But I need before to save date in database to do some checks with the inc/dec date. Cal you help me ?
Thanks, Rosen "John W. Holmes" <[EMAIL PROTECTED]> wrote in message 002301c29960$21d6a360$7c02a8c0@coconut">news:002301c29960$21d6a360$7c02a8c0@coconut... > > 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