List:General Discussion« Previous MessageNext Message »
From:Shaun Date:January 16 2006 2:47pm
Subject:Re: UPDATE Date Column
View as plain text  
Thanks Patrick,

Will this work on 3.23?

""Patrick Herber"" <patrick.herber@stripped> wrote in message 
news:001001c61aa9$cb1257d0$9501a8c0@DEEPBLUE...
> 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