Re: Date problem

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" <holmes072000@charter.net> wrote in message 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... > >