Will this work on 3.23?
""Patrick Herber"" <patrick.herber@stripped> wrote in message
> 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: