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
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