From: Martijn Tonies
Date: January 16 2006 3:15pm
Subject: Re: UPDATE Date Column
List-Archive: http://lists.mysql.com/mysql/193905
Message-Id: <009e01c61aaf$b677a090$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

> 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 - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


> > Do you mean something like that?
> >
> > UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH)