List:General Discussion« Previous MessageNext Message »
From:Patrick Herber Date:January 16 2006 2:33pm
Subject:RE: UPDATE Date Column
View as plain text  
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
> 

Thread
UPDATE Date ColumnShaun16 Jan
  • Re: UPDATE Date ColumnAdy Wicaksono16 Jan
  • RE: UPDATE Date ColumnPatrick Herber16 Jan
  • Re: UPDATE Date ColumnShaun16 Jan
  • Re: UPDATE Date ColumnMartijn Tonies16 Jan