Friday, 9 August 2013

How to substract one month in SYSDATE() in mysql?

How to substract one month in SYSDATE() in mysql?

My Database date is like "2013-07-09" that is 9th August. SYSDATE() is
"2013-08-09" that is also 9th August. When i am going to take data into
database using this SYSDATE() in takes 08 which is month number is
September. So I want to subtract one month in SYSDATE().

No comments:

Post a Comment