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