Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DATE_ADD corrigendum
Corrigendum to my last question The statemant I use is UPDATE TClient SET cli_fact_start = ADDDATE(cli_fact_start, INTERVAL 1 MONTH) -
DATE_ADD
Hi I have to increment a date (cli_fact_start in date format) adding all the time 1 month.... OK I do that with UPDATE TClient SET cli_fact_start = TIMESTAMPADD(MONTH, 1, cli_fact_start) When the date is 2004-01-31 it gives 2004-02-29 Super... exactly what I wanted... However the next one it...
