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 Yell
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://lis