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