Select tomrows date

[bob_the _builder]

Hi,

 

How can I check mysql date/time field for all records with tommorows date.. ?

 

 

Thanks

[xyph]

You want to use a mix of NOW() and DATE_ADD()

 

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add

[bob_the _builder]

Hey,

 

From my understanding this should work..

 

SELECT *  
FROM timeslots
WHERE timeslot = NOW(DATE_ADD(timeslot, INTERVAL 1 DAY)) 

 

But it returns no rows and no errors.. Is there a problem with the fact the field is formated DATE/TIME aposed to DATE?

 

Thanks

[xyph]

NOW() isn't supposed to take arguments.

[Deoctor]

try this

select date_format(CURRENT_TIMESTAMP() + interval 1 day,'%Y-%m-%d %H:%i:%S') as tomorrow;

 

 

you can use this without the date_format if you like to get exactly the same format as now(). like this

 

 

select (CURRENT_TIMESTAMP() + interval 1 day);