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