From: Eric Bergen
Date: July 4 2004 5:08pm
Subject: Re: date and time functions.
List-Archive: http://lists.mysql.com/mysql/168408
Message-Id: <11b1bd9904070410087c6c38e9@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Date modification functions are listed in the manual here:

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

If you are just trying to add a year to a  column try something like this.

update table set col = col + interval 1 year;

-Eric


On Sun, 4 Jul 2004 18:22:04 +1000, Hari Yellina
<yellina@stripped> wrote:
> Hi All,
> 
> I trying to add one year to date function is there a good documentation on
> how we can manipulate on date function.
> 
> Changing the format of dates for mysql.
> 
> Thank you ,
> 
> Harry
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
>