List:General Discussion« Previous MessageNext Message »
From:Ady Wicaksono Date:January 16 2006 2:31pm
Subject:Re: UPDATE Date Column
View as plain text  
Hi Shaun

You could use DATE_ADD function with interval negative


Shaun wrote:

>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 
>
>
>
>  
>


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