MySQL Lists: mysql: Re: UPDATE Date Column

List:	General Discussion	« Previous Message Next Message »
From:	Ady Wicaksono	Date:	January 16 2006 2:31pm
Subject:	Re: UPDATE Date Column
View as plain text

Hi Shaun

You could use DATE_ADD function with interval negative


Shaun wrote:

>Hi,
>
>I have a 2 Date Columns in my table, how can I update the 2nd date column so 
>that the dates are 3 months previous to the orignial date column for every 
>row.
>
>Thanks for your advice 
>
>
>
>  
>

Thread
• UPDATE Date Column	Shaun	16 Jan
• Re: UPDATE Date Column	Ady Wicaksono	16 Jan
• RE: UPDATE Date Column	Patrick Herber	16 Jan
• Re: UPDATE Date Column	Shaun	16 Jan
• Re: UPDATE Date Column	Martijn Tonies	16 Jan