List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:January 16 2006 3:15pm
Subject:Re: UPDATE Date Column
View as plain text  
> 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)

Thread
UPDATE Date ColumnShaun16 Jan
  • Re: UPDATE Date ColumnAdy Wicaksono16 Jan
  • RE: UPDATE Date ColumnPatrick Herber16 Jan
  • Re: UPDATE Date ColumnShaun16 Jan
  • Re: UPDATE Date ColumnMartijn Tonies16 Jan