Mysql's Now() +1 Day

Select records from NOW() -1 Day

Judging by the documentation for date/time functions, you should be able to do something like:

SELECT * FROM FOO
WHERE MY_DATE_FIELD >= NOW() - INTERVAL 1 DAY

MySQL's now() +1 day

You can use:

NOW() + INTERVAL 1 DAY

If you are only interested in the date, not the date and time then you can use CURDATE instead of NOW:

CURDATE() + INTERVAL 1 DAY

How do I select between the 1st day of the current month and current day in MySQL?

select * from table_name 
where (date between  DATE_ADD(LAST_DAY(DATE_SUB(CURDATE(), interval 30 day), interval 1 day) AND CURDATE() )

Or better :

select * from table_name 
where (date between  DATE_FORMAT(NOW() ,'%Y-%m-01') AND NOW() )

How to select rows that have current day's timestamp?

use DATE and CURDATE()

SELECT * FROM `table` WHERE DATE(`timestamp`) = CURDATE()

Warning! This query doesn't use an index efficiently. For the more efficient solution see the answer below

see the execution plan on the DEMO

Fetching rows with updated at timestamp older than 1 day in mysql

You can't use DATE on an integer timestamp value; you must convert it to a DATE using FROM_UNIXTIME:

SELECT COUNT(*) 
FROM a
WHERE FROM_UNIXTIME(updated_at) < NOW() - INTERVAL 1 DAY

Note that you don't have to use DATE_SUB to subtract an interval, you can just write the arithmetic directly.

MySQL CURDATE() + INTERVAL 1 DAY not returning as should

job_date_start seems to have a time component. You need a date range or just the date:

WHERE job_date_start >= curdate() + interval 1 day and
      job_date_start < curdate() + interval 2 day ;

Or:

WHERE DATE(job_date_start) = curdate() + interval 1 day

The first is safer for indexes.

---

Related Topics