What exactly do you want to do? I'm not a mind reader... ---John Holmes...
> -----Original Message----- > From: Rosen [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 01, 2002 12:54 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] 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" <[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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php