MySQL: How to add one day to datetime field in query

Posted by phpBOY on Stack Overflow See other posts from Stack Overflow or by phpBOY
Published on 2010-05-11T12:11:38Z Indexed on 2010/05/11 12:14 UTC
Read the original article Hit count: 234

Filed under:
|
|
|

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.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql