Re: UPDATE Date Column

[Ady Wicaksono]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]