> 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) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]