MySQL: How to add one day to datetime field in query
- by phpBOY
Hello,
In my table I have a field named eventdate in datetime format like 2010-05-11 00:00:00.
How do i make a query so that it adds one day to the eventdate eg if today is 2010-05-11, i want to show in where clause to return all records with tomorrow's date.