Wednesday, 28 August 2013

How to Add month to a date while keeping the last month of a given month

How to Add month to a date while keeping the last month of a given month

Can somebody help me on how to add month to a date while keeping the last
day of that month?
Suppose I have updated the first data on 2013-01-29, so when adding one
month to that date, it will be 2013-02-28. But everytime I add one month
again on the latest date, it becomes 2013-03-28 but it must be 2013-03-29.
What would be the perfect command in mysql query that I can use.
Thanks in advance.

No comments:

Post a Comment