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:

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
Upscene Productions
Database development questions? Check the forum!

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

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