> 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 -
t;
>> -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 have a 2 Date Columns in my table, how can I update the 2n
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 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
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://li
