My problem is that I want to add a date column in this format 2016-08-13 exactly in this Order I achieve it with this:
DATE_FORMAT(NOW(),'%y-%m-%d')
but now I need the same format but adding 30 days something like that but I have no idea
DATE_FORMAT(NOW(),'%y-%m-%d')+30
The detail is that when I make the symbol +30 I get this 0000-00-00, how can I solve it?
Use Interval with the number of days:
or you can use the DATE_ADD() function:
This worked for me once to add days to a date: