> Will this work on 3.23?
>From what I can read here:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
yes, it should.
Nevertheless, it might be wise to FIRST tell the list your MySQL version
and THEN ask for solutions to a problem...
--
Martijn Tonies
Database Workbench -
Thanks Patrick,
Will this work on 3.23?
""Patrick Herber"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Do you mean something like that?
>
> UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH)
>
> Regards,
> Patrick
>
>> -Original Message-
>> From: Shaun [mailt
Do you mean something like that?
UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH)
Regards,
Patrick
> -Original Message-
> From: Shaun [mailto:[EMAIL PROTECTED]
> Sent: Monday, 16 January 2006 15:27
> To: mysql@lists.mysql.com
> Subject: UPDATE Date Column
>
> Hi,
>
> I h
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 Genera
