Do you mean something like that?
UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH)
> -----Original Message-----
> From: Shaun [mailto:shaunthornburgh@stripped]
> Sent: Monday, 16 January 2006 15:27
> To: mysql@stripped
> Subject: UPDATE Date Column
> 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: