MySQL How to add one day to datetime field in query

Question

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

User · Answer

If you are able to use NOW   this would be simplest form   SELECT   FROM  fab scheduler  WHERE eventdate gt   NOW   - INTERVAL 1 DAY   AND eventdate lt NOW   ORDER BY eventdate DESC    With MySQL 5 6  query abowe should do  Depending on sql server  You may be required to use CURRDATE   instead of NOW   - which is alias for DATE NOW    and will return only date part of datetime data type

User · Answer

date   strtotime date  Y-m-d   strtotime  date        1 day      Or  simplier   date  Y-m-d H i s   time     60 60  24

User · Answer

How about this  nbsp   select   from fab scheduler where custid   1334666058 and eventdate   eventdate   INTERVAL 1 DAY

User · Answer

Have a go with this  as this is how I would do it     SELECT    FROM fab scheduler WHERE custid    123456  AND CURDATE     DATE DATE ADD eventdate  INTERVAL 1 DAY

User · Answer

You can try this   SELECT DATE DATE ADD m inv reqdate  INTERVAL   1 DAY   FROM  tr08 investment

User · Answer

It s possible to use MySQL specific syntax sugar   SELECT     date field   INTERVAL 1 DAY   Looks much more pretty instead of DATE ADD function

User · Answer

You can use the DATE ADD   function       WHERE DATE DATE ADD eventdate  INTERVAL -1 DAY     CURRENT DATE   It can also be used in the SELECT statement   SELECT DATE ADD  2010-05-11   INTERVAL 1 DAY  AS Tomorrow   ------------    Tomorrow      ------------    2010-05-12    ------------  1 row in set  0 00 sec

[mysql] MySQL: How to add one day to datetime field in query

Examples related to mysql

Examples related to sql