KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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. Update: I tried this: select * from fab_scheduler where custid = 1334666058 and DATE_ADD(eventdate, INTERVAL 1 DAY) But unfortunately it returns the same record even if i add an interval greater than 1. Result: 2010-05-12 00:00:00 But i only want to select records with tomorrow's date.
Tags (comma-separated)
Save Edits
Cancel