Re: date and time functions.

[Eric Bergen]

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=1
> 
>